In the Click event procedure of the button to remove the filter, add this
line of code:
Me.FilterOn = False
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Derek said:
I have created a filter button using the wizard, but what do I change to
do the remove filter button?