Erattic Report Printing (1 Viewer)

I have an Accesss 2010 database that prints reports. The user selects various records in a table and based on the key ID, it prints a report for each record in sequence. The first two or three reports print correctly. Then it reprints a previous report repeatedly up to the number of records that have been selected.

The printing is duplex as each report has two pages.

Stepping through the code, a new SQL is created for each report and the data in each is correct. Then when the code is sent to the printer it prints a report with previous data or sometimes repeatedly prints the second or third report.

I have inserted DOEVENTS throughout the code that generates the SQL statements and that does not correct the eratic performance.

Anyone have some clues. I'll be most appreciative of your help.

Thanks

I discovered the problem and solved it.
I had failed to close each report after I printed it.

DoCmd.Close acReport "ReportName"