Check item as completed when printing report

kbrooks

Still learning
Local time
Yesterday, 22:51
Joined
May 15, 2001
Messages
202
I have a database where a handfull of users enter charge corrections they want me to make to patient accounts. Periodically I print out a report, make the corrections, then go back in to the databased and mark them as completed. I have a field called Completed that is a check box and I literally just check them off.

I'd like to have them check off automatically as I print the report. Is there any way I could do that? I supposed I'd need a confirmation box so I could verify that, yes, the report did print. Otherwise if the printer jams or whatever else, the data won't be marked off.
 
Open a message box on the close event of the report and then run or don't run an Update Query dependant on the result, the problem will come of course if only some of the report has printed in which case you might have to let users pick from a multiselect list box
 

Users who are viewing this thread

Back
Top Bottom