How do you update a table after you print a report

[petite39]

I have a report that's recordsource is a query that has a huge date calcuation in it. So whatever records finally end up in the query...I print the report for each record. So 20 records, 20 pages of the same report.

I want to update a field in a table called PrintedReminderLetter, it's a yes/no field. I'm stumped as to how write the code behind which report event? Do I somehow have to access the query at the time the report opens and update that records source?

I'm sure it's been done before....I just never did it.

Any help would be appreciated.

Thanks.

 

[maxxximaniac]

on close event of the report... you can run an update qry to change the y/n from 0 to -1 or whatever...

DoCmd.OpenQuery "qry_Update"