Updating Report Recordset after Printing

[HowieZ]

First, I have a form which prompts the user for some report criteria. Then I open the report and build the SQL recordsource of the report based on the selections from the user prompt form. All of this works fine.

Lastly, after the report prints, I need to update a certain field's value based upon the report printing for that row in the table.

I'm not sure if I can access the report's recordset to do this, or do I need to write an update query with the same selection criteria as the SQL recordsource?

Thanks,

Howard

 

[Travis]

Write the Update Query with the same criteria. (Save yourself the headache of have to deal with the report being opened from Preview or Print)