I am trying to figure out how to check to see if the user clicked 'Ok' or 'Cancel' when I use the printout method. If they click 'Cancel', I need to prevent records from being updated.
Thanks
Printable View
I am trying to figure out how to check to see if the user clicked 'Ok' or 'Cancel' when I use the printout method. If they click 'Cancel', I need to prevent records from being updated.
Thanks
VB Code:
Report.PrintOut True, 1 If Report.PrintingStatus.Progress = crPrintingCancelled Then ElseIf Report.PrintingStatus.Progress = crPrintingFailed Then ElseIf Report.PrintingStatus.Progress = crPrintingNotStarted Then ElseIf Report.PrintingStatus.Progress = crPrintingHalted Then ElseIf Report.PrintingStatus.Progress = crPrintingInProgress Then ElseIf Report.PrintingStatus.Progress = crPrintingCompleted Then End If
Thanks again RobDog888.
No prob.