VBA Script to mark off items once printed?

  • Thread starter Thread starter Lord-Data
  • Start date Start date
L

Lord-Data

I have a record set that I'd like to keep for printing of individual
"tickets", which use a Yes/No field that is marked for printing or not in a
Form. I then have a report that uses a query to bring up only entries marked
for printing, and displays them 6 up on a page. The question is, I'd like to
use the On Print event of the report, or a button, once it is printed, I'd
like it to automatically switch the Yes/No field back to no.

Whats the rough procedure for doing this?

Thanks in Advance!
 
you can user UPDATE QUERY to do these

SQL code like these

update tablename set yes_noField=no where id=1
 
Back
Top