Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    LookUp list not alphabetized (2000)

    Hello

    One table in my database is a listing of all employees (4 fields in table = SSN(primary key), first name, last name, and department). The table is sorted alphabetically by last name. Using the lookup wizard, I made a lookup list in a second table (training class attendance) to enter who went to what classes. In the wizard, when chosing what fields to be my lookup columns, I chose the last name and first name field and kept the key column (SSN) hidden. But when I click the drop-down arrow in the table or form to enter data, the list is not shown alphabetically by last name and so it's not saving me any time. Is there a property I can set to affect how the lookup list is shown?

    Thanks all

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LookUp list not alphabetized (2000)

    Use a query instead of a table. Select the sorting order desired, and use that as the basis for the form.

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

    Re: LookUp list not alphabetized (2000)

    Amplifying on what Peter said, if you look at the [Row Source] property for the drop-down combo box (in design mode), and click in it, you will see the builder ellipsis (...) on the right hand side. If you already have the table name in the property and you do that, it will ask you if you want to make a query from that table, and if you say yes, it brings up the familiar query grid. Put in the sort you want, then close the query grid and it will ask if you want to save it to the property. A very powerful and quick way to do what you want.
    Wendell

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LookUp list not alphabetized (2000)

    WOW - that could not have been any easier!!
    Thank you both VERY much!

Posting Permissions

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