Clicking a button to auto update a field

[winnieisme]

I would like to to be able to push a button that will update a field named processed after a report has been printed. Right now when we hit the print button it prints all the work orders. I want to be able to print only the newest one.

 

[Blorf]

Processed is a yes/no field?

I am assuming that when bulk print work orders, you print all that have processed set to no, then want to ask the user if he wants to set the printed status or processed field to yes?

If so, then on your reports on exit event, you can write a little vba to use a message box to ask (Or skip that if you don't want to give an option), and run the code to mark them with a docmd.runsql statement like this

docmd.setwarnings false
docmd.runsql "UPDATE Yourtable SET Yourbable.Processed = Yes;"
docmd.setwarnings true

ChaZ


"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert