1 record report

[eyalco]

When printing an invoice, the report shows all records instead of the 1 record from the invoice.
How do I make sure that only 1 record will show in the report (the report is based on a query, BTW)
Thanks.

 

[Rabbie]

How many records does the query return. do you set any criteria when you open the report?

 

[boblarson]

As alluded to by Rabbie, you would open your invoice report by doing this:

DoCmd.OpenReport "YourReportNameHere", acViewPreview,,"[YourSaleIDNumber]=" & Me!YourSaleIDNumber

And you would replace the applicable parts with the names of your actual report and fields on the report and the field on the form which identifies the sale uniquely.

 

[eyalco]

Thanks, it works - I have only 1 record but there are no details in the form )it gets out empty and with errr in the calculated fields.
Sorry bother you guys but help??