Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5605
  • 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?
0
Patrick O'Dea
Asked:
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.

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

(Much friendlier for the novice users of my system)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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