Here is the SQL version of my query criteria: WHERE (((tblMain.Subject) Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*")); In my query criteria it looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*". My question is, if the user enters a first letter that doesn't exist I want a msgbox to pop up stating "not found" instead of just having a blank form open. Thanks for any help
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!