Search through a table using multiple Criteria from a Form

[Tdahlman]

I use a form [frm_Flooring] to enter in several different types of floor
styles. Each type of flooring has certain characteristics (i.e. Material,
Color, Sizes, Price, etc.)

I would like to create another that allows me to do a query using multiple
criteria.
For example I would open the form and have 5 different text boxes (or combo
boxes) that each assigned to a certain criteria. One would be color, another
would be Wood Species, etc.
I can use this form to run a query based on a single criteria, but I want to
be able to fill in a couple different boxes and use all the criteria as well.

Any idea please let me know.

Thanks in Advance
Travis

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The article contains a downloadable example of how to build a filter string.

(This does assume you have a normalized data structure, not a different
table for each type of floor.)