Viewing report before printing using DoCmd.Printout
Posted on 2006-06-08
I have a report that when viewed - the message box opens that asks a user if they want to print the report. Then once the report has printed another message box appears that asks if the users wants to update the record. That works fine but the problem is that when the user views the report the message box automatically appears and it does not allow the user to view the report or zoom in or out because the message box is displayed. Is there anyway to allow the user to view and then come back to the message box or is there a way to run code after a person clicks on File - Print. That way I can take the message box out and have the update code to run after a person Prints the file.
Also, is there anyway to pull up the print preview/properties dialog box using a DoCmd.Printout or how is that done.