Code Examples

Toggle Filter

acCmdCreateShortcut

This routine allows you to turn an existing Filter On and Off. There are a number of steps required to ensure this example works.

  1. Add the code to a module
  2. Add a buttons to a toolbar
  3. Set the action for the new toolbar item to
    =TBToggleFilter()
'***************** Code Start *******************

Function TBToggleFilter()
  DoCmd.RunCommand acCmdToggleFilter
End Function

'****************** Code End ********************

© 1998 - 2011 Terry Wickenden TKW Design Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.