Empty Report Message?

[mrf1xa]

I have a cost/benefit report for which the user selects the month from a form before opening the report- no problem.
What I would like to do is to check whether there is any data present for the chosen month, before the report is opened, and if there is none display a message box saying this instead. What's the easiest way to go around this please?

Thanks

Nigel

 

[smedvid]

On the report form, check out the NoData Event. What I typically do is create a Macro (even though I try to avoid them) with 2 items: MessageBox(with your message) and a CancelEvent. Another approach, I've also done is to do a simple DCount() on the table/query used to see if any records are returned. These are a couple of options, I am sure there are others... htwh... Steve Medvid
"IT Consultant & Web Master"
web page under development...

 

[Garridon]

Also check this FAQ:

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

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

 

[mrf1xa]

Thanks for both responses- Steve's suggestion works a treat and will no doubt find its way into many more of my applications over time.

Nigel

 

[car54]

Please advise where the NoData Event is located. I dont have one.
Do I need to create one??

 

[smedvid]

The NoData Event is located on the Report Form. Open the Report form, select properties. Next, press the Events tab and there it will be... Steve Medvid
"IT Consultant & Web Master"
web page under development...