Two sorting levels in combo dropdown?

G

Guest

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
Open form for record selected in combo 2
Switching off grouping *and sorting* in a report? 2
Sorting records within a subform based on two control fields 2
Limiting the contents of combo box 1
Sorting and grouping list totals 1
Combo Boxes 2
OL2013: Goofy sorting order for e-mails within a conversation 1

Top