Combobox Filtered Search

[dgwynn]

I have a search form with comboboxes that works well. What I'd like it to do is filter the choices available according to information entered in the previous box. For example, all drop down lists in each box will contain all information from tables/queries available but if I type in "Smith" in the Last Name box, I'd like the First Name drop down list to show only first names available for those students with the last name of "Smith." Any suggestions?

[orange]

I think the name of what you are looking for is cascading Combo.
See the free video tutorials here
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[dgwynn]

Thank you, orange. Works very well! Another question, if I may. Is there a way to search the contents of multiple fields from a single combo box and return all results?

[orange]

It's better (simpler) to have a separate textbox for each field to be searched.
see http://www.datapigtechnologies.com/f...earchform.html