Trap 2 Error Messages On A Button In Form

Hi, I have a button in a form that loads a report, if there is no data in the report then 2 error messages are displayed, however as these messages have no affect and they do no harm as such I would like to prevent them from being displayed. The error messages are error 91 “invalid use of isnull” error and error 2501 “cancel event error message”

I’ve been able to prevent either error 91 from being displayed or alternatively 2501 using a single if statement but not both of them together using two if statements.

(If error 94 is displayed, I would still like the report to open, error 2501 is displayed after the report is closed if there’s no data & i just want this message not to be shown)

Any ideas what im doing wrong? :confused: any help much appreciated

Regards

Kevin


Below code works ok (to trap just the one error message):

Err_cmdPreview_Click:
If Err.Number = 2501 Then ' ignore cancel event error
Else
MsgBox Err.Number & " - " & Err.Description
End If
Resume Exit_cmdPreview_Click

End Sub


But the below code here doesn’t work (when I use 2 if statements to try & trap both of the error messages)

Err_cmdPreview_Click:
If Err.Number = 94 Then ' ignore isnull error
DoCmd.OpenReport stDocName, acNormal

Else
If Err.Number = 2501 Then ' ignore cancel event error
Else
MsgBox Err.Number & " - " & Err.Description
End If

Resume Exit_cmdPreview_Click

End Sub