Is there a way to craft a message box alerting user if record [match]not found before [empty] report

[joeyej]

I have a query that searches records on last name using parm "Like
[Enter Technician Last Name: ] & "*"". My client [details] report
opens up empty if no match. Is there a way to craft a message box
alerting user if record [match] not found before report opens?

 

[Dennis]

Reports have an 'On No data' property so you can put this code in there

Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data"
Cancel = True
End Sub

 

[joeyej]

Reports have an 'On No data' property so you can put this code in there

Private Sub Report_NoData(Cancel As Integer)
    MsgBox "No data"
    Cancel = True
End Sub

I have a query that searches records on last name using parm "Like
[Enter Technician Last Name: ] & "*"". My client [details] report
opens up empty if no match. Is there a way to craft a message box
alerting user if record [match] not found before report opens?- Hide quoted text -

- Show quoted text -

Many thanks!