I have a page for instance:
That I have filtered on the recordset such as this:
and it's working fine. What I want to do is then filter based on category, for instance, "Category1" or "Category2".
Can I use a dynamic drop down for this and how do I apply it to the page so it is still filtering what is above but ALSO the specific category? or should I just add the category to the search string somehow? But how do I filter that when it changes?
I'm assuming I have the drop down right above the recordset and whatever the user chooses, it will go to that category?