Automaticly clear checkmarks

  • 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?
 
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?
Click to expand...

Add a Command button to the form.
Code it's Click event:
CurrentDb.Execute "Update MyTable set MyTable.[Print] =
0;",dbFailOnError

Change MyTable to whatever the actual table name is.

**After** you are sure the report has successfully printed, click the
command button to reset all records.

NOTE: Print is a reserved Access/VBA/Jet word and should not be used
as a field name.

For a more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html
 
Back
Top