J G
asked on
message box if no filter results
I have a unbound search text box on a form that has a table record source. I also have a button that will execute a filter with the following macro builder code:
[PLU] Like "*" & Forms![Item_Master]!Search Feild & "*"
I want to display a message box if no filter results are found. How can I do this?
[PLU] Like "*" & Forms![Item_Master]!Search
I want to display a message box if no filter results are found. How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Figured it out! go to new record
ASKER
Is there any way to add some vba code that will select the bottom empty row and clear the form everytime someone hits the button to execute the filter?