Thanks for all the suggestions. I'll try to better explain my needs. I do believe this will require VBA. I have created a sample table below:
Code:
ID Color Shape Size
1 red circle small
2 green square small
3 red rectangle medium
4 yellow square large
I would like to create a form using a field list combo box to have the user select Color, Shape, or Size as the criteria field from the combo box(1). Say the user selects Color from the field list combo box another combo box(2) would list red, green, yellow. These two combo boxes would make up the WHERE statement of my query: WHERE combo box(1)=combo box(2). The field list combo box is easy. I just don't know how to get that information from the form into the query. My real table has dozens of fields and that is why I don't want to create/maintain several "static" queries, when a "flexible" one sounds like a good idea.
Thanks again!