multiple reports

[DS]

How can I generate multiple copies of the same report (each will report a differnt set of data). The criteria for each report is held in a table, one record for each copy of the report.

I currently loop through this table, alter the query used by the report and then execute docmd.openreport "reportname", previewmode. This simply brings up one copy of the report representing the first set of data.

Thanks in advance
DS

 

[chrismcbride]

One simple solution might be to alter the structure of your loop so you first set out a pre-set number of iterations that will represent the number of copies of each report that you want. Inside that loop, put the code for re-defineing the query and printing the report. That way you open and print on copy of the specific report for each iteration of the report.
Hope this helps...
Chris