Report errors

[car54]

Please advise why my Reports work with no errors and then when the database was initialized with zero records then the report numbers show "ERROR" messages.

If I put data in the database it shows the numbers and everything looks okay and the "ERROR" messages disappear. How can I make the "ERROR" messages not show up (in the numbers area) when there are no records in the database??

 

[Garridon]

You're getting the #Error because Access doesn't have any data for the reports. You can set up an On No Data event procedure so your user won't see the errors. Just see this FAQ:

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

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

 

[car54]

Thanks
The only thing I cant find is the "On Data" event procedure for my report.

I clicked on properties and do not see this. I see "On click" "On Double click" etc...

This is on Access 2000.

 

[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

 

[mrf1xa]

Sorry, posted in wrong place, reposted as new thread!