Printing a report from Form and Subform

[Guest]

iI am trying to print a report (invoice) from a form and a sub form.

I want to hit a button on the main form to be able to print the invoice.

The form and subform are based on two tables with a one-to-many relationship.

The many relationship is the subform.

How do i go about this in order to print only the current visible record in
the many relationship.

 

[Al Campagna]

randalizm,
Your form/s should be related by some key field unqiue value. ex. CustID, or
InvoiceNo, etc... that identifies that record and that record only.
In the query behind your report, include that field with a criteria of...
= Forms!YourFormName!InvoiceNo
The report will only return the data for the current record on the open form.