Blank Reports to not open

[Emma]

Hi I have 3 reports which open from a macro. I would like the reports to be
displayed if there is information, however if the report is blank I don't
want to open it. Is there a setting which stops blank reports from openning?

 

[BruceM]

See VBA Help for information about the report's NoData event. Essentially
it is something like this:

Private Sub Report_NoData(Cancel As Integer)

MsgBox "No data"
Cancel = True

End Sub

 

[Emma]

Hi Bruce that worked great really liked the pop up msg! Thanks

 

[BruceM]

Glad to help. Check Help about message boxes to see how to add titles and
other features.