Limiting report contents to query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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

DoCmd.OpenReport "ReportName", acViewPreview, ,Me.Filter
 
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.
 
Back
Top