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
Discuss This Question: