code to delete filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top