Automate the Uncheck

[Kevbro7189]

In my main Table I have a field called [Print]. It's a Yes/No check mark. I
use this field to let me know if a record needs to be printed, it's
automatically filled in as "-1" when the record is first generated. Through
a Query (to find these records) I have a form that lists all the records that
needs to be printed, so the user can double check them before printing.

My problem is the user has to manually uncheck the [Print] field after they
print the records. How can I go about and automate this process to uncheck
the field when the print button is pressed?

 

[Steve Schapel]

Kevbro,

Make an Update Query to reset this field for all records. The SQL view of
sucha query would look somewhat like this:
UPDATE NameOfYourTable SET Print=0 WHERE Print <>0

Then add an OpenQuery action to your macro to run this update at the same
time as the report is printed.