report cancelling

[dott]

I am using docmd.cancelevent in the on no data event in my report but for some (stupid) reason access is telling me 'The OpenReport action was cancelled.'

Is there anyway around this ridiculous error message?

 

[jeremie_ingram]

Go to the error handler in the code and change the Msgbox Error$ to MSGBOX ERR.NUMBER and then when this problem is encountered it will show you the error number that was encountered. Then, in the error handler (what is triggering this event) put and If statement to bypass this event.

Event_Error
If Error.Number = #### (number associated to that error)Then
resume Event_Exit
Else
MsgBox ERROR$
resume Event_Exit
End IF