Sorting records in a Combo with code??

[caferacer]

Hi All,

Can you have a saved (unsorted) query as a row source for a combo and then add some code to enable the combo to sort the list?

Reason is, I want three combos to use the same query for finding records in different ways, but need the query to be saved, not a query built by the query builder that access takes you into from the row source on the combo data tab?

I only need the data listed in each of the combos to be sorted by one column in each of the combos.

Have seen something about bubble sorting, but not sure if this is OTT or even could be applied to this?

FYI, this is not a cascading situation.

Thanks and regards

 

[AOB]

Why not sort the results in the RowSource property of each combobox?

So combobox 1 can be :

SELECT [qrySaved].* 
FROM [qrySaved] 
ORDER BY [Field1]

Combobox 2 can be :

SELECT [qrySaved].* 
FROM [qrySaved] 
ORDER BY [Field2]

etc etc (you should probably specify the fields to be returned rather than using the asterisk but just as a pointer)

 

[caferacer]

So simple. Thank you.