Checking for empty/null results

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

A report is created when a button is pressed in my Access
97 database application. This report retrieves its data
from a query that runs in the background. I want to check
to see if that query came up with an empty set, and if it
did show a messagebox indicating no data, otherwise, show
the report like it does now. I want to implement this so
a report with no data won't appear; thus limiting user
confusion.
 
You can use the NoData Event of the Report.

Check Access VB Help on the NoData Event.
 
Back
Top