Limiting report contents to query results

  • Thread starter Marguerite Hall
  • Start date
M

Marguerite Hall

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.
 
F

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

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

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

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.
 
Top