On No Data Event

[itprog]

I have the On No Data event of my report show a message box that no data exists for the time period entered. The message box works, but the report still opens showing errors because there is no data. Is there a way for me to stop the report from opening after I display the message box?

 

[daveUK]

Before the code from the form opens the report type:

On Error Resume Next

So the code behind your form should look like

On Error Resume Next
DoCmd.OpenReport "NameOfReport"

HTH

 

[itprog]

I have multiple reports I would like to use this code in. If I save this code as a module, can the On No Data event call a module? If so, how?