Dropdown filter all in recordset
I'm stumped on this and it's probibly a really easy fix...I hope!
I have a drop down menu list that filters my recordset, so each dropdown value retrives a list of say product brands, when you start off on the results page all records are viewaible, then they change dependant on what you have selected, my challange is how do I then get, from the drop down menu the complete (all) records to view again.
Mike