I have the following code on the NoData Event
in a report.
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data to Display"
Cancel = True
End Sub
If in fact no data is found for the report I then
get the following error message
"Run time error 2501 the OpenReport
action was cancelled"
I need to get rid of the error message. Why does
it appear anyway ? The idea of the Nodata event
should have sorted it out.
Can anybody help please
Many thanks
in a report.
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data to Display"
Cancel = True
End Sub
If in fact no data is found for the report I then
get the following error message
"Run time error 2501 the OpenReport
action was cancelled"
I need to get rid of the error message. Why does
it appear anyway ? The idea of the Nodata event
should have sorted it out.
Can anybody help please
Many thanks