drop-down list for query parameter

[Guest]

Hi. I have a simple query parameter in which I would like
to have a drop-down list (instead of blank field). For
example, before I see query for students I would like to
be prompted with a list of teachers.

I'm sure this is a very simple issue, I just can't seem to
find answer in online help or elsewhere. Thanks in
advance for any info and/or ideas.

 

[Allen Browne]

You can only do this with a form.

Create a form with a combo box that has its RowSource set to the table of
teachers.

In the Criteria row under the relevant column in your query, enter something
like:
[Forms].[Form1].[cbo1]
replacing "Form1" with the name of your form, and "cbo1" with the name of
your combo.

Make sure the form is open, and the desired record selected before running
the query.