Report Recorcset

[CA_IT]

I have researched this and found lots of hits on the topic, but no actual
solutions -

I am creating a report based on a query, and once it is printed, if the user
indicates that the printing was successful, I would then like to mark each
item as printed. All is good with one exception.

It is very possible, that the data will change ( new items meeting the query
criteria ) during the print cycle. Therefore, using the same query, and
marking those records as printed, may actually mark new records that were
not in the original query, as printed. I therefore need to generate an
exact recordsetclone of the report as generated. This is of course very
doable from a form, but, not a report, so, the $6M question is

How do I get an exact clone of the records displayed on the report?

Thanks!

 

[TC]

The Print event (or whatever it is) could add the primary key value of
the just-printed record, to an array or collection. Then you know
exactly which records were printed, without having to re-run the query
/or/ access the underlying recordset of the report.

HTH,
TC (MVP Access)
http://tc2.atspace.com