How to change combo box list display order?

[Guest]

I have a combo box where the "Row Source Type" is set to "Table/Query" from
another form in the same database. Although the source data is sorted and
displayed in A-Z format, the combo box is displaying the data in the order it
was originally entered (that is, the order in which the records were added to
the source). So if the user clicks on the box and looks for their selection,
they might not see it because it is not in alphabetical order. If the user
types the name directly into the combo box, the right choice will eventually
be displayed. I also ran a test and added a new record to the source data.
It correctly put the new entry in alphabetical order in the source form, but
it came up at the very end of the combo box list.

Is there a way to have the combo box display a dropdown list of choices in
the same order as the source data is displayed? Or is there a way to force
the combo box to run an A-Z sort of the available choices before displaying
the dropdown list? I can't find anything helpful in online help.

Any assistance would be greatly appreciated.

 

[Douglas J. Steele]

Create a query that returns the data in the order you want, and use the
query, rather than the table, as the combo box's rowsource.

Tables don't actually have a guaranteed order, so this is always the
preferred method.

 

[Guest]

Thanks -- that worked (with a little tweaking)!

Create a query that returns the data in the order you want, and use the
query, rather than the table, as the combo box's rowsource.

Tables don't actually have a guaranteed order, so this is always the
preferred method.