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

  • Thread starter Thread starter Boon
  • Start date Start date
B

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
 
Boon said:
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.)
Click to expand...


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))
 
Back
Top