Hi all,

I have never programmed in VB and I created a database that has a search field. The problem is when a user types in a data that is not in the database, it would still look give a result. For example, the form has a field to search for a lot number. If the user puts a lot number that is not in the database, how would I code it in VB? I appreciate the help I can get. Thanks.