Error Trapping for Report with Blank Records

[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.

 

[Jeff Boyce]

Depends on which version/release of Access you are using. Check the
report's No Data event, in which you could add a msgbox.

 

[Guest]

Thanks that was very helping. I forget about that event.

 

[Van T. Dinh]

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.