Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    20

    Unanswered: order by in button

    I have a list of programs (about 500) in a form and I need do create a button that and cliked it order de programs asc ou des. I dont know if its best to program the event in VB or if it can be done with some property of the access 2000, like a macro or something..
    thanks in advance
    Fallen

  2. #2
    Join Date
    Feb 2002
    Posts
    64
    Setup a textbox on your form with the control source as the field(s) you want to sort by. (I cleverly named mine RecordSort.) Setup up your button as follows:

    DoCmd.GoToControl "RecordSort"
    DoCmd.RunCommand acCmdSortAscending

    Of course you can put the A/Z graphic on your button too...

  3. #3
    Join Date
    May 2002
    Posts
    20

    thanks

    thanks for the help

Posting Permissions

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