Sorting Records

[Nathan]

When I create a combo box on a form the records are
displayed in no particular order. I want the records to be
displayed in alphabetical order.
I was advised to base the form on a query. I hve tried
this and it has not helped. I have tried sorting the query
and then displaying the results from it in a combo box.
However the records appear in the order they were created.
Could you please let me know where I am going wrong or
advise another way around the problem.
Thanks in advance

 

[John Spencer (MVP)]

Base the combobox on a query.

Click on the combobox control
Click on the properties for the combobox
Click on the Data tab
Click on row source and then click on the three dots at the end
If it shows the name of a table then it will ask if you want to create a query
Say yes, if it shows a query already then it will open up
Modify the query to show the fields you need in the combobox
Sort by the field(s) you wish to display the data.
Close and save

That should do it.