S
sanndipannandyi via AccessMonster.com
How I will list of country in combo box for MS Access
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Al Campagna
Several ways to do that.
1. Create a ValueList foir the combo...
USA ; Canada ; France ; etc.....
or
2. Create a one field table, like tblCountries, with all your countries
entered there, and use that table/query as the RowSource for your combo.
or
3. Use the Country field entries you've already used in previously
entered records as the RowSource for the combo.
For example, you have a tblCustomers, with customers from many countries
already enetered there.
Use the Country field from that table as the RowSource for the combo.
You should see all the countries you've already entered against your
customers listed in the combo (use a Totals query to display just one
instance of each country)
Given the following Customer data
First Last Country
------------------------
John Smith Canada
Jane Brown USA
Bill Jones France
Joe Davis Canada
A combo using a Totals query (GroupBy) on the Country field would yield a
list like this...
Canada
France
USA
If you set the LimitToList of the combo to NO, and you gave a new customer
record a country of "England"... from then on, England would be added to the
combo listing.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
1. Create a ValueList foir the combo...
USA ; Canada ; France ; etc.....
or
2. Create a one field table, like tblCountries, with all your countries
entered there, and use that table/query as the RowSource for your combo.
or
3. Use the Country field entries you've already used in previously
entered records as the RowSource for the combo.
For example, you have a tblCustomers, with customers from many countries
already enetered there.
Use the Country field from that table as the RowSource for the combo.
You should see all the countries you've already entered against your
customers listed in the combo (use a Totals query to display just one
instance of each country)
Given the following Customer data
First Last Country
------------------------
John Smith Canada
Jane Brown USA
Bill Jones France
Joe Davis Canada
A combo using a Totals query (GroupBy) on the Country field would yield a
list like this...
Canada
France
USA
If you set the LimitToList of the combo to NO, and you gave a new customer
record a country of "England"... from then on, England would be added to the
combo listing.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
G
Guest
Al Campagna's option 3 works very nicely. You will probably want to requery
the combo control after adding a new customer with a new country so that the
new country will show on the list immediately.
the combo control after adding a new customer with a new country so that the
new country will show on the list immediately.
Al Campagna said:Several ways to do that.
1. Create a ValueList foir the combo...
USA ; Canada ; France ; etc.....
or
2. Create a one field table, like tblCountries, with all your countries
entered there, and use that table/query as the RowSource for your combo.
or
3. Use the Country field entries you've already used in previously
entered records as the RowSource for the combo.
For example, you have a tblCustomers, with customers from many countries
already enetered there.
Use the Country field from that table as the RowSource for the combo.
You should see all the countries you've already entered against your
customers listed in the combo (use a Totals query to display just one
instance of each country)
Given the following Customer data
First Last Country
------------------------
John Smith Canada
Jane Brown USA
Bill Jones France
Joe Davis Canada
A combo using a Totals query (GroupBy) on the Country field would yield a
list like this...
Canada
France
USA
If you set the LimitToList of the combo to NO, and you gave a new customer
record a country of "England"... from then on, England would be added to the
combo listing.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
B
Bob Howard
This is the source of country / mailing information I use for my commercial
Access application. I've found it to be the most comprehensive around. Of
course, you'll have to get it into Access your own way. Bob
Access application. I've found it to be the most comprehensive around. Of
course, you'll have to get it into Access your own way. Bob
Al Campagna said:Several ways to do that.
1. Create a ValueList foir the combo...
USA ; Canada ; France ; etc.....
or
2. Create a one field table, like tblCountries, with all your countries
entered there, and use that table/query as the RowSource for your combo.
or
3. Use the Country field entries you've already used in previously
entered records as the RowSource for the combo.
For example, you have a tblCustomers, with customers from many countries
already enetered there.
Use the Country field from that table as the RowSource for the combo.
You should see all the countries you've already entered against your
customers listed in the combo (use a Totals query to display just one
instance of each country)
Given the following Customer data
First Last Country
------------------------
John Smith Canada
Jane Brown USA
Bill Jones France
Joe Davis Canada
A combo using a Totals query (GroupBy) on the Country field would yield a
list like this...
Canada
France
USA
If you set the LimitToList of the combo to NO, and you gave a new customer
record a country of "England"... from then on, England would be added to
the combo listing.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html