Error on cancel (1 Viewer)

[dullster]

I have reports that are triggered off parameters. When the first parameter request comes up, if i cancel, I get "The OpenReport operation was canceled". How do i get it to cancel without the error?

This is my code

Private Sub btnPrintChecks_Click()
DoCmd.OpenReport "rptChkWrite", acViewPreview
End Sub

 

[Pat Hartman]

How do i get it to cancel without the error?

This is standard Access behavior. To stop it, you need to add error trapping to your procedure. Usually the error will be 2501 but sometimes you get a different error. If you get a different error, modify the first select case line to"
Case 2501, xxxx ' action cancelled
to add the second error code to the ignore case

Private Sub btnPrintChecks_Click()
On Error GoTo Proc_Error

DoCmd.OpenReport "rptChkWrite", acViewPreview

Proc_Exit:
   Exit Sub

Proc_Error:
    Select Case Err.Number
        Case 2501     'action cancelled
            Resume Next
        Case Else
            MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure btnPrintChecks_Click of VBA Document Form_yourformname"
    End Select
    Resume Proc_Exit
    Resume
End Sub

 

[Gasman]

That is not an error, merely an informative message.

 

[June7]

I never use popup input parameters in queries. I prefer VBA to build filter criteria and apply to form or report. Get user input on form and validate before even attempting to open.

If I did need a dynamic parameter in query, I would reference a form control for input and still validate.

However, error handler tested and works.

 

[Pat Hartman]

I agree with June about the parms. It is far better to have the user enter them on the form where you can validate them and ensure they are there before you try to open the report. But, you should still include error trapping when your code opens another object regardless since there are other situations where your user will cancel the action and generate this error. If you want the user to see the error, you could leave it untrapped but I'm not recommending that.