message when no results for the report are returned

[Guest]

Is there a way I can have a message come up when no results are returned for
a report? I have some reports where the title includes the criteria entered
by the user when the report is run (for example, a date range). When no
results are returned, I would like to give the user an error message stating
that. As it is, when there aren't any results, the title of my report
displays - "Error".

Thanks!

 

['69 Camaro]

Hi, Lori.

When no
results are returned, I would like to give the user an error message
stating
that.

You can display a custom message for the user in the report's NoData( )
event. For the VBA code, please see the link to the tip, "How to prevent a
blank report from displaying," in the "Reports" section of the following Web
page:

http://www.Access.QBuilt.com/html/how-to_tips.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.