use print command from floating menu which would trigger an update in a field

[LisaMK]

Would like to let the user to preview an invoice and then decide if it needs to be printed or not. If the user decides to print the invoice from the Orders form, a field called DatePrinted field on the Orders form will be updated with the current date. Would like the user to use the print command from right clicking over top of the report and select print from the floating menu.

Thank you for any direction that can be offered

 

[doran_doran]

Similar Method.....

http://support.microsoft.com/default.aspx?scid=kb;en-us;146310

------------------------------------------------------------------

You can follow similar footstep. Upon opening the report you can pop up a form with txtCurrentDate and default that date to today's date now() or date().

Then, put a print button and make sure in the sql code or vb code you filter only today's order (or today's date).

Good Luck.
Dianna Goldsberg