Print labels and update a field on table

[m2boost]

Hi guys,



What I will like to do is print some labels from my database (already doing this) and when they are printed update that record on the table to be marked as printed on a Yes/No or even a field that say printed.

Is that possible? I just don't want to print the same label twice by accident.

Thanks,

Ernesto

[Bob Fitz]

I would suggest adding a date field to the record which could be updated with Now() using an Update query each time the print command is run. Using Now() to mark each record might be useful if the print fails for some reason (paper jam, no ink etc)

[m2boost]

I would suggest adding a date field to the record which could be updated with Now() using an Update query each time the print command is run. Using Now() to mark each record might be useful if the print fails for some reason (paper jam, no ink etc)

Like running the update query from the same click event procedure?

[Bob Fitz]

Like running the update query from the same click event procedure?

YEs. I assume that you click a button to invoke the print. Somewhere in that buttons click event code will be a line that sends the record to the printer. You would run the Update query in the next line of code.