I have an Access dropdown box that's based on a distinct list of all records in the query that is the datasource for that form.
I want that dropdown box to serve as a filter on the data that will show up in the form. (It's a continuous form.)
How do I do this?
Also, I'd like one of the choices to be "ALL", and to not filter the data, but to show all records.
How can I accomplish this?