Display Message if No Data Exist in a report

[carmina johnson]

I need to display a message on a report if there is no data to report

[Steven Kogan]

Place this code in the report's NoData event:

Private Sub Report_NoData(Cancel As Integer)[INDENT]MsgBox "There is no data"[/INDENT][INDENT]Cancel = True[/INDENT]
End Sub

[carmina johnson]

Thanks for your help Steven!