Blank Reports to not open

  • Thread starter Thread starter Emma
  • Start date Start date
E

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?
 
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
 
Glad to help. Check Help about message boxes to see how to add titles and
other features.
 
Back
Top