On No Data Event 3

[Mike555]

What syntax is used in a <b>On No Data</b> event that closes the report (or just stops it from displaying in the first place), if there is no data?

Thanks.

 

[CosmoKramer]

It should be as easy as:

Cancel = True

 

[Mike555]

This works. Thanks!

 

[CosmoKramer]

I forgot to mention that you could also add a MsgBox function to inform the user that no records were found:

MsgBox ("No records met your criteria")
Cancel = True

 

[Mike555]

That's even better. Thanks!

 

[RLA]

This is very helpful, thanks! One other question -- I get a Run-Time Error '2501' when my report closes. Is there a way to avoid the error?
Thanks!

 

[CosmoKramer]

Are you opening this report through a command button? Could you post the code from the On Click event?

 

[Garridon]

This FAQ covers Error 2501:

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=1594

 

[Mike555]

One more question: Is there a way to define what words appear on the title bar of the dialog box? By default it just says Microsoft Access. Thanks.

 

[CosmoKramer]

Sure...

MsgBox "No records met your criteria", , "Custom title Here"

The third argument is for the title. Check out the MsgBox function in access help to see more arguments such as the type of buttons, icon style, etc.