Easy way to clear subform sorting filters

[database_1]

So I have a search form for the database I made. The search form has a subform table which shows the values searched. I realized the subform table had it's own filters and sorting on the top of each header the user can use. I was wondering if there was a way to code a button so when it is pressed, it resets the fitlers and sortings on the subform table that the user put? Thank you for your time.

-Thomas Ward

[CJ_London]

the click event for a button to clear the filters would have code something like

me.filter=""
me.filteron=true
me.orderby=""
me.orderbyon=true

if the button is on a main form and you want to clear a subform then replace me with subformname.form

[Micron]

Isn't it enough to simply write Me.FilterOn = False? Can't say I've ever tried, but it seems that it should be sufficient.

[CJ_London]

that just stops the filter - the filter string is still populated

[Micron]

Sure, the property has a value, which you'd over-write the next time you want to set it in code. However the filter is turned off, which I thought was enough to remove the form filter. I'm just going by M$:

You can remove a filter by choosing the pressed-in Apply Filter button, choosing Remove Filter/Sort on the Records menu, or using Visual Basic to set the FilterOn property to False.

[CJ_London]

guess you can - it's just the way I've always done it