Sort in a ComboBox

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I have a ComboBox that is bound to a FULL NAME field in my table. When I
look at the ComboBox in the form the names are not in alphabetical order.
How do I change that?

Thanks
 
Tiffany said:
I have a ComboBox that is bound to a FULL NAME field in my table. When I
look at the ComboBox in the form the names are not in alphabetical order.
How do I change that?
Click to expand...

Edit the RowSource and add an OrderBy clause to the query.
 
Do not bind the control to table. Create a query, sorted on the desired
field and bind that to the control's rowsource.
 
Back
Top