Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    UK
    Posts
    246

    Unanswered: anyone know what the command is for this?

    Hi,
    Probably very easy but I can't see it, but what is the VBA command for the following menu function on a form so that I can invoke it via a command button

    Records : Remove filter/sort

    Regards
    John

  2. #2
    Join Date
    Apr 2004
    Posts
    173
    i generally don't use the menu button command i do this ->

    me.filteron = t/f
    me.orderbyon = t/f

    hope that helps

  3. #3
    Join Date
    Nov 2002
    Posts
    154

    Thumbs up VB answer

    The command in Access 2000 and 2002 is
    DoCmd.RunCommand acCmdRemoveFilterSort
    Have fun!

  4. #4
    Join Date
    Feb 2004
    Location
    UK
    Posts
    246
    Thanks guy's for your help.

    Feetdontfailme, I used you example and it works perfectly but I still can't find it in Access help for some reason! Oh well all sorted now
    Regards
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •