I have a form with a combo box where the user selects a value from the list.
I then have a query that uses this value as the imput to a filter
Next on the After update of the combo box I set the filter using the code
What VBA Code can I use to remove the filter and return to the all records view?
What event should I use to to remove this filter? Add a button "Remover Filter"
Is there a more efficient method to set this filter from VBA code without using the Query and remove it when desired?.
Thanks all for your assistance