drop-down list for query parameter

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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...
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.

I have a similar scenario and I have successfully used the combo box value as
a parameter in a Access query. I now need to take two fields returned from
the query and place them in text fields in my form. How would I go about
manipulating these controls in my form?

Thanks,
Tom

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...
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.