Need to append data once it is printed on a report.

[ddt1972]

I have a database where the management screens jobs for the techs to do, and they print them out one record at a time to hand them out. I am trying to figure out how to have the record added to the working table for the techs to be able to update status once the manager prints it. The techs do not have access to the managers list of jobs, so I am thinking an append query? How would I run the append query upon hitting the print button? Thanks in advance for all the help. I am using Access 2003, by the way, and I have a limited knowledge of VBA, so some code is ok.

 

[Isskint]

After the report has been printed from the buttons OnClick event use SQL or a call to an update/append query to the working table.

EG

DoCmd.OpenReport rptName,acViewNormal

DoCmd.OpenQuery qryUpdateWorkTable

 

[ddt1972]

Thanks for the response, sorry for the late reply. I have been under the weather, will try that and post back.