Can you fill a query parameter from a list ?

[john]

I have a DB with details of about 60 countries. I have a query that
selects part of the details for a given country based on a parameter I
type in when the qury runs. These details are then printed from a
report.

Rather than having to type in the individual name of the country I
need the details from I would like to be able to select it from a list
or combo box or similar. The names are historical can can be easy to
miss-spell.

Any Thoughts

BTW Access 2002 / 2003 (home and work)

John

[pietlinden]

create a form with a combobox - use the table containing the 60 country
names as the rowsource.
Say your form is called frmGatherCriteria and your combobox is
cboCountry

Then your query would look something like

SELECT somefield
FROM sometable
WHERE Country=[Forms]![frmGatherCriteria]![cboCountry]

[john]

On 18 Aug 2005 15:20:15 -0700, pi********@hotmail.com wrote:

create a form with a combobox - use the table containing the 60 country
names as the rowsource.
Say your form is called frmGatherCriteria and your combobox is
cboCountry

Then your query would look something like

SELECT somefield
FROM sometable
WHERE Country=[Forms]![frmGatherCriteria]![cboCountry]

Sorry perhaps I did not make myself clear enough. When I ope the
repot the query behind it runs and that pous up the parameter box. It
is then I would like to have a drop down with a list oc country names