Filter data in a Report

[ayjayh]

I have constructed a Query form to edit two tables. The main table is a list of items in shipments received from many different suppliers and each shipment received is given a login number.
In the Query form I do a Find and Filter by Selection to restrict the data to a particular Log number.
I have made a Report to summarise the shipment received but it insists on printing out the complete information from all shipments.
How can I filter the Report so it only prints the records for the Login number I have filtered out on my Query form

Tony

 

[David R]

DoCmd.OpenReport "ReportName" , , , "[IDField] = " & Me.IDField

Note: This assumes the code to open the report comes from your query form (otherwise Me.IDField won't work), that [IDField] is numeric, and that you want to print it directly. If you want to preview it first, look up the options for the OpenReport method.

HTH,
David R