I have an app that is developed in Access 2003 and distributed with the
Access2007 runtime.
I am using custom filters and when records are filtered I show the
chosen filter on a coloured caption on the form.
So far so good BUT when a user clicks on the filteroption in the
horizontal scrollbar all the records are shown... I am still showing a
caption that is false information at that time.
I would like to get rid of the option all the way but I fear that is not
possible?
I know I can set the AllowFilter property for the form but that is not
what I want.
I still want to be able to use other standard filteroptions to further
narrow-down the returned recordset.

Any ideas?

ArnoR