On No Data error

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

I have this report which on no data, pops up a message saying so.

The problem is it works fine on the mdb, but when I do it on the mde, the
message comes up but when I click to close the message, this error message
comes up.

"The erpression On CLick yoiu entered as the event property setting produced
the following error: The OpenReport was canceled."

How do I overcome this?

Thanks in advance.

Richard
 
I guess the strange thing is why you don't get the error message in the
regular mdb (you should).

However, you simply need to trap the error in the code that CALLS THE
reprot.

So, just go:

on error resume next <-----add this line before your open reprot..
docmd.OpenReprot "your reprot",acViewPreview
 
Thanks Albert

I was wondering too how come the mdb doesn't show the message. Will do as
you suggest.

Thanks again
Richard
 
Back
Top