How I get a MsgBox to appear for a query that doesn't produce data

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

Guest

I have a Access DB that will query a table looking for a specific date. I
would like a message box to appear when the query doesn't have any data for
that date. When data is present for a date the query usually will open an
report and displays it.
 
I have a Access DB that will query a table looking for a specific date. I
would like a message box to appear when the query doesn't have any data for
that date. When data is present for a date the query usually will open an
report and displays it.
Click to expand...

Queries don't open reports.
Reports use a query as their record source.
If the query is the Record Source of a report, code the Report's
OnNoData event:

MsgBox "No data to report for this period."
Cancel = True

If the report has been opened from an event this will generate Error
2501.
Trap the error in that event.
 
Back
Top