Selection List Items Not Sorted When Select From Combo List

[davesaint86]

I created a single column table. I sorted the data in the table ascending. I created a data entry form with a combo selection box. In the combox box properties I set the row source to the appropriate table. When I select from the drop-down my list of data is not sorted ascending. How do I fix this?

 

[FancyPrairie]

There are at least 2 ways to do it:
1. Create a query that sorts the data in ascending order.
And then set the Rowsource equal to the query.
2. Set RowSource of combobox to "Select YourFieldName From YourTableName Order By YourFieldName;"