code to delete filters

T

Ted

in a2k i find the help docs tell the user to use the Advanced Filter/Sort
tool thing which takes him to the query design view wherein the user clicks
on Edit and then 'Clear Grid', which is lastly followed by hitting the 'Apply
Filter' tool thing.

there must be some way some VBA code could be rigged to be the Click event
of a cmdbutton, no?
 
A

Allen Browne

To remove the filter and show all records:
Me.FilterOn = False

You can execute the Click event of a command button name "Mybutton" with:
Call MyButton_Click
 
Top