parameter query in list

[Guest]

Hi i would like to make a list of students in a seminary from a specific
country. I would like to base it on a parameter query of field country and
then each time the user will be asked Enter the country you want and the
report will show the list of that specific country.

But is there any way of showing the user the list of countries available in
the query to choose from and instead of the little parameter box coming up
the list of countries comes up and the user just has to click on the country
that he wants - how can this be done?

 

[John Spencer]

You can do this but it requires using a form to get the information and then
code on the form to call the query - or better to display the data on a form
or in a report.

Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm


A brief quote from an John Vinson (Access MVP) posting.

You'll need to create a small unbound Form (let's call it frmCriteria) with
a Combo Box control (cboCrit) on it. Use the combo box wizard to select the
table for the selections, and be
sure that the bound field of the combo is the value you want to use as a
criterion. Save this form.

Now use

=[Forms]![frmCriteria]![cboCrit]

as the criterion in your Query.

It's convenient to base a second Form or Report on the resulting query to
display the results; if you put a button on frmCriteria to launch that form
or report, the user can enter the criterion and view the results in one
simple operation!

Quoting John Vinson

Keywords: Parameter Queries