How can i make my form searchable?

[emerlita]

I have a form and i want to be able to change what's in the combo box
to look for the entries on that selected item.

 

[Allen Browne]

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.