close report when there is no data to display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What code would I use to automatically close a report that has no data? I
have played around with the 'on no data' code but am not good enough yet to
get it to work.

Please help!
 
BLTibbs said:
What code would I use to automatically close a report that has no data? I
have played around with the 'on no data' code but am not good enough yet to
get it to work.
Click to expand...


The NoData event procedure only needs the one line:
Cancel = True
between the Sub and End Sub statements.

Don't confuse the OnNoData property with the NoData event
procedure, The OnNoData property must be set to
[Event Procedure]

After you get that working, you will receive a message box
stating that the report was cancelled. If you are opening
the report from a form button's Click event, you can
suppress the message by ignoring error number 2501. Post
back with the code for the button's procedure if you need
help straightening this out.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error in the report when no data 3
Is Null in a Report 2
"On No Data" causes crashes 7
Access Access Report Works on One Machine but not Another 3
Report with No data Input 3
Excel VBA - Problem with Closing Print Preview 0
closing a form with no data to display 2
Closing A Report 2

Back
Top