Greekiwi
asked on
Filter form via dropdown menu
I have a form (well a series of forms but I will start with just one) that contains records. One of the fields of the records is a status one. The actual field is based off its own table. What I want to do is have a dropdown menu in the header of the form (a multirecord form) that will filter it based on the selection in the drop down menu. An option to clear the filter would be nice as well.
I know that I can do this from the controls in Access but I would really like this functionality so the end user for the database has that option.
I know that I can do this from the controls in Access but I would really like this functionality so the end user for the database has that option.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
lol, we all do it mate, your welcome
ASKER