What is the best way to create a report based on one record? 2

[doctorjman]

I am developing a database that tracks sales and inventories. I need to create several reports that are based on one record like an invoice or bill of lading. What is the best way to create it?

 

[JerryDennison]

Create the report as you normally would. Then from the screen that displays the individual record (i.e. Form) add a button to open the report. The wizard should prompt you if you want to limit the report based on the current record. If it doesn't you can manually add the where claus to the line of code that opens the report. To do this use the following syntax:

Docmd.OpenReport "ReportName", acViewPreview, , "[Primarykey] = " & Me.PrimaryKey

Substitute your report name and record id for the placeholders given.

 

[doctorjman]

Thank you very much Jerry.

 

[JerryDennison]

You're welcome.