G
Guest
I'm trying to ensure a report will not print if there is no data... I've
looked in the help and suggests to put
Private Sub Report_NoData(Cancel As Integer)
MsgBox "There are no records to report", vbExclamation, "No Records"
Cancel = True
End Sub
for the Event Procedure in NoData
I've done exactly what it said, but its not working - does it not work with
subreports in a main report? I've tried with just the main report having the
code and then all of the subreports as well but it still prints.... argh.
looked in the help and suggests to put
Private Sub Report_NoData(Cancel As Integer)
MsgBox "There are no records to report", vbExclamation, "No Records"
Cancel = True
End Sub
for the Event Procedure in NoData
I've done exactly what it said, but its not working - does it not work with
subreports in a main report? I've tried with just the main report having the
code and then all of the subreports as well but it still prints.... argh.