Access 97 - Sorting Data in List Box Field

[tpearo]

I have a drop down list box on a form that allows the user to select a customer name from the list. This list comes from a table called Cust_tbl. The Cust_tbl field is customer name. This field is sorted alphabetically, however the names in the list box do not show up as sorted. I need the list box also to be sorted alphabetically. What's the trick????

 

[Guest_imported]

click on the 3 dots next to the row source. this will open a query build click sort ascending on the row you want to sort on click yes to save changes.