sorting values in a combo box

[109bow]

Evening all, hoping someone can help with this one,
I have a combo box in a form which gets values from a query, the order of the records is already sorted in the query based upon another field.
Is it possible to order the records in the combo box? I have read it should be done in row source, but I already have the code
SELECT [cal equip].[asset no] FROM [cal equip],
in it, I don't know how to add to this code to sort the records.
Many thanks, in advance

 

[pbaldy]

SELECT [cal equip].[asset no] FROM [cal equip] ORDER BY DesiredFieldName

 

[109bow]

Your a genius! many thanks

 

[pbaldy]

Happy to help!