Answered
Recordset question
Noob question here. Couldn't find answer in the archives.
I can use the AND and/or OR statements all day long fine for simple filter
results.
Now I have a search form where there are several drop down fields to filter
with. I need to be able to have one user search maybe search with the Country
and State dropdowns, whereas another user might want to search using the
Gender and Height dropdowns.
In short, is there a way to create a recordset that will allow me to filter by
all, some and/or one dropdown depending on the users wishes? I see it done in
websites all the time but am not sure how it's handled.
I can use the AND and/or OR statements all day long fine for simple filter
results.
Now I have a search form where there are several drop down fields to filter
with. I need to be able to have one user search maybe search with the Country
and State dropdowns, whereas another user might want to search using the
Gender and Height dropdowns.
In short, is there a way to create a recordset that will allow me to filter by
all, some and/or one dropdown depending on the users wishes? I see it done in
websites all the time but am not sure how it's handled.
AdChoices