On No Data error

[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

 

[Albert D. Kallal]

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

 

[Richard]

Thanks Albert

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

Thanks again
Richard