I have a subreport with a No Data event:
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No Data"
Cancel = True
The msgbox displays when I open the report separately but as expected the sub report msg box will not display when opening the Parent report and I do not want the msg box to display. Instead, I want the subreport to display text "No Data" so that it could be seen on the printout.
How can I do this? thank you