Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box search Order (Access 2000)

    I am using a combo box to look up data on my forms. It works fine except it doesnt show the names in the combo box in alphabetical order. If I enter "J" it doesnt give me all the "J"s just one.

    Any help??

    Dan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box search Order (Access 2000)

    Create a query that sorts the names in ascending order, and set the Row Source of the combo box to the name of this query.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Combo Box search Order (Access 2000)

    You probably want to use a query as the data source of your combo box. Click the builder button to the right of the Row Source and it will bring up the QBE grid for queries. In the query, tell it to sort by the names, and then close the QBE grid. It will ask if you want to save it - say yes and you will now have a query string as the Row source.
    Wendell

  4. #4
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box search Order (Access 2000)

    Thanks!

Posting Permissions

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