Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Location
    Lancaster PA, USA
    Posts
    33

    Unanswered: alphabetize items in a drop down box

    Ok, this is a noob question.... I have a table with two fields ColorID and CName. I'm listing the names (CName) in a drop down box and I want them to show up alphabetically. They're currently showing up numerically by ColorID. I know this is incredibly simple to do but I seem to have forgotten how.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Try entering this into the row source
    Code:
    SELECT ColorID, CName
    FROM YourTable
    ORDER BY CName
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2005
    Location
    Lancaster PA, USA
    Posts
    33
    Arrrggghhh! That was so easy haha. 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
  •