Error Trapping for Report with Blank Records

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

Guest

I need to set up a condition for error trapping blank records in a report
action.

Popping up a message box, before the report is displayed.
 
Depends on which version/release of Access you are using. Check the
report's No Data event, in which you could add a msgbox.
 
There is a NoData Event for the Report. If this Event occurs, the
RecordSource of the Report is empty and you can use this to pop up your
message (and cancel the opening of the Report).

Check Access VB Help on NoData Event.
 
Back
Top