The simplest, if not the most efficient is to use the WhereCondition
argument for the DoCmd.OpenReport method. It allows you to filter the
records to be printed.
This is well described in the Access help function.
If you are dealing with a lot of records it would be quicker to create an
SQL string for the RecordSource property for the report and set it as the
RecordSource for the report. You could do that in the Report_Open event sub.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
