Run-time error 2501; OpenReport action was cancelled

[ShanVel]

Paul & boblarson,
Here's the sample database per your request. I would appreciate your time.

Thanks.

 

[boblarson]

Get rid of the DoCmd.Echo commands. That's what's causing it to lock. Once I removed those, it worked great.

 

[ShanVel]

boblarson,
Thank you very much. I tested and yes it solved the problem when I removed DoCmd.Echo, but users have to deal with blinking screen every time they click search button. That's OK. Now I can move on. Thanks for all your time and other folks who were kind enough to devote their time in looking into this problem and offered their ideas.

Shan.

 

[suepowell]

Hi Paul,

You've just explained in one simple sentence why it used to work and now doesn't. I had been playing with the error handling option, and had forgotten to switch it back to break on un-handled errors.

Thanks for that it just saved me hours of frustration cos I knew I had solved it and my cade was there and corect.

Sue

 

[pbaldy]

Glad it helped you, Sue!

 

[jrw1]

I had this problem - after searching many forum found that removing all printers and reinstalling them resolved the problem.

 

[Jonathan Sklar]

You probably have the Error Trapping level set to Break on All Errors (vba options). Change it to Break on Unhandled Errors and you will be okay.

 

[pbaldy]

You probably have the Error Trapping level set to Break on All Errors (vba options). Change it to Break on Unhandled Errors and you will be okay.

That was addressed 6 years ago.