Sort in a ComboBox

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
 
R

Rick Brandt

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.
 
H

hal boyles

Do not bind the control to table. Create a query, sorted on the desired
field and bind that to the control's rowsource.
 
Top