Cancelling openning of report if no data is in the report

[Rufusjeep]

Have a report that is based on a query, use a form with an option group to determine what information is needed to be reported. Using filters to restrict the information that is displayed on the report.
What I want to do is have a message box pop up on the screen and tell the user that there is no information to report and cancel the openning of the report.

Any ideas would be great.

Thanks,
Mike

 

[Garridon]

See this thread:

thread703-214198 Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[andyparker]

Dear Mike
To Solve Your Problem go to the Property sheet of the report.There select the Event Tab.In That there is an event called "On No Data",There you can write your macro or a code to display an appropriate message.Also If you use an event procedure, use the MsgBox statement to display a message, and set the Cancel argument of the Report_NoData Sub procedure to True.
Hope It Solves your Problem.
Anand...