Cancelling a Report in the Middle of Running It

[EddieN1]

I have a report that prompts the operator to change printer forms based on the process of a report. Currently, I put up an OkOnly msgbox to "Change the Form to xxx, etc.". I want to give the operator another option using an OkCancel type msgbox where if she clicks on Cancel, the report terminates. I tried using a docmd.close, but I got a runtime error stating "This action can't be carried out while processing a form or report event." I currently have the code in the GroupHeader0_Print event. Any help would be appreciated.

[ItsMe]

What factors determine which form is used?

I suggest you analyze whatever the process is BEFORE you send the print job to cue. After you send the print job to spool it is in the printer's hands and out of the control of your application. You might be able to write code that would access the properties of the printer and cancel a job that has been sent to the printer.

You might be able to access the Printer's properties and tell the printer which tray to use before sending the print job to the printer.

[June7]

MsgBox popup can take one of two forms.

1. simple message with only OK button as response
MsgBox "This is my message"

2. a function that can offer multiple response buttons
If MsgBox("This is my message", vbOkCancel) = vbOK Then
'code to print report
End If