Limiting report contents to query results

[Guest]

I want to automatically limit the records in a report to the results of a
query by form. That is, without having to manually enter a query parameter
for the records to be printed.

 

[fredg]

I want to automatically limit the records in a report to the results of a
query by form. That is, without having to manually enter a query parameter
for the records to be printed.

Code the click event of a command button on the form:

DoCmd.OpenReport "ReportName", acViewPreview, ,Me.Filter

 

[StCyrM]

Good morning Marguerite

If your query is the recordsource of your report, then your report will reflect
exactly the result of the query.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.