Mark Record as Printed - Any ideas? 2

[pdldavis]

Hi,

I have a table where records are printed out as individual forms for circuit installation. The records come from a combobox selection and print after update.

I need to prevent these forms from being reprinted. I have a yes/no field in the table to indicate whether or not a form has been issued and I can do this manually, one at a time prior to print. This is cumbersome however, and there are several thousand records.

Is there a method for automatically updating a field in underlying table after print or is there some other way to accomplish this?

Thanks, Dan

 

[Wocca]

Just run a query after your process prints something like

Update YourTable
Set Printed = True
Where YourTable.RecordID = YourForm.RecordID

Regards
Warwick