OrderBy on ComboBox

[Dkline]

I have a ComboBox on a form which needs to be alphabetized. In it source
table, the ID is the Primary Key and is in Column #1. The bound column is
Column #2 - which has the names. I want the names to be sorted
alphabetically in ascending order when selecting from the combobox..

Problem appears to be that the visible portion of the list in the box is the
bound column but the order is set by the ID.

The combobox does not have an OrderBy property. How can I do this?

 

[Gerald Stanley]

Try changing the RowSource SQL to include an ORDER BY
clause to give you the sort sequence that you are after.

Hope This Helps
Gerald Stanley MCSD

 

[Dkline]

Thank you. Glad it was a simple solution.

Try changing the RowSource SQL to include an ORDER BY
clause to give you the sort sequence that you are after.

Hope This Helps
Gerald Stanley MCSD