update query? (2000-SR1)

[wsryan]

I have a report that I print--it is based on a query "ProcessQuery" that brings up all records where the yes/no field "Processed" is "No"
As soon as this report prints, I would like the table to be updated so that all of those previously unprocessed records(and unprinted) automatically get set to "Processed" by changing the yes/no field "Processed" value to "Yes".
How does one do that?

[HansV]

Create an update query that sets Processed to Yes for all records with Processed = No.
You can run this query (using DoCmd.OpenQuery or CurrentDb.Execute) from the On Close event of the report.

Warning: Access doesn't distinguish between previewing and printing a report. You may want to ask the user for confirmation:
<code>
Private Sub Report_Close()
If MsgBox("Do you want to mark the records as Processed?", _
vbYesNo + vbQuestion) = vbYes Then
DoCmd.SetWarnings False
DoCmd.OpenQuery "NameOfTheUpdateQuery"
DoCmd.SetWarnings True
End If
End Sub
</code>
Alternatively, you can open/print the report from a command button on a form. You can also run the update query from the On Click event procedure of the command button.