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