A combo box of countries' name with USA and Canada at the top 2

[Boon]

I want to create a combo box of a list contries. I want it to be in a way
that the first two countries are USA and Canada, and the rest is
alphabetically. (As we have seen so often on websites.)

How can I do this? Do I need to create a table that put the countries in
this format? Currently, my combo box reads the country names from a query.
(That query is the select query that selects unique countries' name from
another table.)

Thanks.
B

 

[Dirk Goldgar]

I want to create a combo box of a list contries. I want it to be in a way
that the first two countries are USA and Canada, and the rest is
alphabetically. (As we have seen so often on websites.)

How can I do this? Do I need to create a table that put the countries in
this format? Currently, my combo box reads the country names from a query.
(That query is the select query that selects unique countries' name from
another table.)

Base your combo box on a query of your original query, along these lines:

SELECT Country FROM qryCountries
ORDER BY IIf(Country="USA", "1", IIf(Country="Canada", "2", Country))