Sort in a ComboBox

[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

 

[Rick Brandt]

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?

Edit the RowSource and add an OrderBy clause to the query.

 

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