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

  • Thread starter Thread starter joeyej
  • Start date Start date
J

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?
 
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
 
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 said:
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 -
Click to expand...

- Show quoted text -
Click to expand...

Many thanks!
 
Back
Top