Cancel report with no record.

[Guest]

Hi

Can anyone tell me how to cancel report if there is no record? I don't like to see a report with error on record fields

Thank you for your time.

 

[tina]

add the following event procedure to the report's module, as

Private Sub Report_NoData(Cancel As Integer)

Cancel = True
MsgBox "Request cancelled - no data available."

End Sub

hth

Hi.

Can anyone tell me how to cancel report if there is no record? I don't

like to see a report with error on record fields.

 

[Ken Snell]

Also note that, if you're opening the report from a macro or VBA code, Error
2501 will be returned by the report to the procedure that opened the report.
If you don't want to see the ACCESS warning "The previous action has been
canceled.", you'll need to trap for this error and stop the error message
from appearing.

E.g.,

DoCmd.OpenReport "ReportName"
If Err.Number <> 2501 And Err.Number <> 0 Then
MsgBox "Error occurred"
End If

 

[tina]

oops, forgot that not-so-minor point. thanks for picking up the slack, Ken!

 

[Ken Snell]

oops, forgot that not-so-minor point. thanks for picking up the slack, Ken!