• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6012
  • Last Modified:

Removing Filter from a subform (datasheet)

I have a form that has a subform.
The subform is a datasheet.
The user can use the standard "filter" funtions in the datasheet.

I need some VBA so that when I click on a button on the MAIN form ... the filters will be removed from the Subform.

How do I use VBA to remove all filters from the subform?
Patrick O'Dea
Patrick O'Dea
1 Solution
Gustav BrockCIOCommented:
The button is already there - below the datasheet: Filter.
Just click it, and the filter is turned off.

Rey Obrero (Capricorn1)Commented:
Me.<NameOfSubformControl>.Form.Filter = ""
Patrick O'DeaAuthor Commented:
Thanks, just perfect.

(Much friendlier for the novice users of my system)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now