See:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
There's a sample database to download.
Copy the module and sample form into your database.
Copy the combo and text box from the sample form onto your form, and set one
property.
You can then use the combo to choose which field to look in, and the text
box to type the value you want to search for.
Although the code itself may look a little scary, it is dead simple to set
up, i.e. you do not have to change anything in the code, or write any code
at all.
