Automate the Uncheck

  • Thread starter Thread starter Kevbro7189
  • Start date Start date
K

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?
 
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.
 
Back
Top