How to Display no Records

  • Thread starter Thread starter Guest
  • Start date Start date
Use the NoData event of the report.

If the event fires, pop up a MsgBox.
 
On the On NoData Property of the report write the code

MsgBox "No Data"
Cancel = True
 
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

Query design 0
Access Access Record Order 0
Report Returned Record Count 2
Message Box Instead of Error 3
Displaying info from multiple records in a report 7
How do I replace #Error in access report with another statement? 4
Display multiple records from same ControlSource 1
counting records 0

Back
Top