Two sorting levels in combo dropdown?

C

CW

I have a combo that displays 3 columns - first the country, then our agents
in each country, then their "preferred status" (a rating from 1 to 3).
At the moment this is sorted by country, so all the agents in each country
are grouped together.
However, it would be even better if the agents within each country were
listed in "preferred status" order from 1 to 3.
Is it possible to have more than one level of sorting within a combo's
dropdown contents?
This is how my Row Source looks now...how would it have to change, to do this?

SELECT Agents.AgtCtry, Agents.AgtName, Agents.PreferredAgtStatus FROM Agents
ORDER BY Agents.AgtCtry

Many thanks
CW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Correct syntax for Find By combo? 2
Total appointments per agent 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
Open form for record selected in combo 2
Programmatically change combo box sorting 4
Command button to change sort order in list 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Vlookup using a dropdwn list, check different tables based on drop 2

Top