VBA Code To Remove Filter From Specific Field

[Aaron5714]

I have a datasheet embedded as a subform. On the main form I want to have a button that will remove a filter set on a specific field in the subform. If the user has set filters on other fields in the subform (using the built-in quick filters) I want to preserve those filters. Is there a way to clear a filter from a specific field without affecting filters that may be set on other fields?



My only idea was to read the subform's Filter property which would return a string with all active filters, then search this string for the field name in question (perhaps using an InStr function) and then work out some logic to delete that portion of the string. Just wondering if there is a more straight-forward way of doing this.

[ItsMe]

I am not aware of the Quick Access Toolbar having the option to filter forms. However, if disabling the control so the user can not filter it is not an option, I can only imagine "parsing" the string as an option.

[Aaron5714]

What I mean by "quick filters" is the filters that a user can select when they click the column headings in a datasheet form; it will open a little menu that allows you to check/uncheck specific values or input a text filter. I thought they were called "quick filters" but I may be wrong. This is different than the Quick Access Toolbar.

Anyway, parsing the string may be the only solution although I was hoping to avoid that approach.

I am not aware of the Quick Access Toolbar having the option to filter forms. However, if disabling the control so the user can not filter it is not an option, I can only imagine "parsing" the string as an option.

[ItsMe]

Thanks for the explanation. I am still trying to learn the Ribbons and Toolbar options in 2010.

[Dal Jeanis]

Yep, they're called "quick filters". As far as I can tell, parsing the form's Filter is going to be your only option, since there doesn't seem to be any documentation regarding a VBA option for turning a particular field filter on or off.