How to sort records in combo box?

[Spyder757]

I've got a combo on my form, it refers to query that has 6 coloums but is only bound to the 2nd.

How can I go about having the records sorted in alphabetical order?

I've tried sorting the query that the combo box refers to but it doesn't seem to work.

 

[jimb0ne]

Is the recordsource of your form set to the query? And is the control source of the combobox set to the Name field from the query? If this is the case, the names should appear in alphabetical order.

Let me know, perhaps you could email me your DB and I could have a look at it.

 

[jimb0ne]

Actually, create a query with just the 2nd column from your other query, then sort ascending.Set the "Row Source" property of the combobox to the name of the query that you just created. This should sort the value alphabetically.