Printing reports froma form

  • Thread starter Thread starter MrC610
  • Start date Start date
M

MrC610

I created an invoice form that feeds data to a printable report version of
the invoice.
Right now, the report uses the criteria [Enter Invoice Number] to view/print
a specific invoice.
Is it possible to add a button on the form itself that will allow me to
print the report for it WITHOUT having to retype the invoice number? I added
a print report button on the form, but it still asks for the Invoice Number.
I hope my question makes sense.

Thanks
 
Chuck said:
I created an invoice form that feeds data to a printable report version of
the invoice.
Right now, the report uses the criteria [Enter Invoice Number] to view/print
a specific invoice.
Is it possible to add a button on the form itself that will allow me to
print the report for it WITHOUT having to retype the invoice number? I added
a print report button on the form, but it still asks for the Invoice Number.
I hope my question makes sense.

Thanks
Click to expand...
Base your report on a query that contains all the fields the report uses. Set
the criteria for the invoice number in the query to :
= Forms.your form name.text box name where you enter invoice number

Put a command button on the form that opens the report but does not close the
form..

The report will look at the query for its data. The query will get invoice
data from the form which, although it may be hidden, will still be open.

Chuck
Click to expand...

THANKS!!! ~MrC610
 
Back
Top