The OnChange event might do what you want... but depending on the size of the recordset you are querying, this could cause unexpected slowdowns because you're requerying the recordset with every keypress. Also, depending on how fast your users type, they might be entering data faster than the query can complete.