Print report from Form (1 Viewer)

[VzqCrs]

Hi, I have a Navigation Form and I've added a report so that it's linked to the form by a field - Link Master Fields and Link Child Field so that the report displays the selected record. How can I get it to print? When the Print window pops up, the whole report is displayed rather than just that one record

 

[The_Doc_Man]

You normally would have to modify the report's .Filter property to select for the single record before printing it, and the VBA call includes a way for you to specify a filter or WHERE clause.

DoCmd.OpenReport method (Access)

Office VBA reference topic

docs.microsoft.com

In this link, you can specify a WHERE clause (without the word WHERE) to act as a filter. If the record has a unique key, you would just use that key to select the single record.