Alphabetize the order of options in a list combo box

[britney]

With help from this forum,I finally got my form bound to a table, and created a combo box with a list of options, in this case they are department names. It works great, and when I select off of the list, it populates the form fields below with their relevant data.



The issue I have now is that my list has hundreds of options, and they are not alphabetized. In my table, I have it set to sort alphabetically by that field. What can I do to alphabetize the list in the form also?

Searching around I have found some websites with direction, including using OrderBy to set the order, but I think I may need more exact direction - where would I put that within the database?

[davegri]

Add the ORDER BY clause to the combobox rowsource.

[orange]

What is the Row SOURCE of your combobox?
Try making it a query with an Order By on the department names.

[britney]

Thanks for your reply, Orange! I couldn't figure out the Order By, but was successful with the Sort Ascending function here.

I used the steps detailed here in an old thread on another site-
https://access-programmers.co.uk/for...d.php?t=240666

[orange]

Glad you have it resolved.

[Micron]

I couldn't figure out the Order By, but was successful with the Sort Ascending function here.

FYI - open the query in sql view and you will see those words. Using the query design interface you'd select Sort Ascending/Descending, but the sql syntax doesn't use "ascending" or "sort".