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