In Access 2007 - Adding a Clear All Filters Button 1

[McLiguori]

I know that the Ribbon and the right click provides a "clear all filters" option. But, I want to add a button to a form that will do this. It is not one of the options available in the Control Wizard.

Thanks for any help you can give.

McLigs

 

[fneily]

You can reset the forms recordsource. On the OnClick event of the button, place:

Private Sub Command101_Click()
Dim SQLText
Dim holda As Integer
SQLText = "Select * From [tblTable] "
Forms![FormName].RecordSource = SQLText
End Sub

Substitute your table name and form name.

 

[McLiguori]

Thanks so much fneily. Did the trick perfectly.