OrderBy on ComboBox

  • Thread starter Thread starter Dkline
  • Start date Start date
D

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?
 
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
 
Thank you. Glad it was a simple solution.

Gerald Stanley said:
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
Click to expand...
 
Back
Top