Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Allowing the user to sort the list in a combo

    Dear loungers,

    I have a combo that shows a multi-column list, it is sorted by the first colum but under ceratin circumstances the user will find it more usefule to be sorted by column two. Is there a way of allowing the user to click the column header to sort the list?

    Manay thanks.......................... liz

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately the standard Access combo box doesn't provide the capability to do that sort of thing. One possible workaround would be to use a double-click in the combo box to change the Row Source of the combo to sort on the second column. That requires some VBA code of course.
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Ah, so I'll dust down my vba, Thanks Wendell.................... liz

Tags for this Thread

Posting Permissions

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