I am trying to run a list of reports. Some reports have no data so should not open or print. How do I only open and print each report that has data.
I have used Has Data in each report to not open and show "No Data" message if selected indevidually but I cannot use this if I want the application to just ignor a report when printing automatically from a list(14 Reports)
I tried to count the records in the underlying query but I must have something wrong:
Architraves is the underlying query of one of the reports.
Private Sub Command17_Click()
If (IsNull([Architraves]![AccountCode])) Then
MsgBox "No Reports data available"