Display message if filter returns no results

[tylerg11]

Hello,



I have a question regarding filtering on an access form. When users apply a filter on the form, if there are no results, the form appears "blank". I'd like to pop up a message that tells the users that no results were returned. Is there any VBA to account for a simple filter not returning results?

Thanks.

[June7]

In the code that runs the search.

If IsNull(some field or control name here) Then MsgBox "No records match the search criteria. Try again."