How do you make an interactive prompt

[Andy S.]

I'm trying to figure out how to make the results of one query be
available as a dropdown menu prompt for the criteria of another query. Is
there an easy way to do this/ I'm doing this to avoid typos, when prompting
the user for criteria with the [].


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************

 

[Duane Hookom]

Avoid using parameter prompts. Use controls on forms for filtering
queries/reports/forms.

 

[Andy S.]

I would filter, but a parameter prompt is needed because it will vastly
improve performance. How I would implement a control?

Avoid using parameter prompts. Use controls on forms for filtering
queries/reports/forms.

--
Duane Hookom
MS Access MVP
--

I'm trying to figure out how to make the results of one query be
available as a dropdown menu prompt for the criteria of another query.
Is there an easy way to do this/ I'm doing this to avoid typos, when
prompting the user for criteria with the [].


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************

 

[Duane Hookom]

http://www.fontstuff.com/access/acctut08.htm

--
Duane Hookom
MS Access MVP
--

I would filter, but a parameter prompt is needed because it will vastly
improve performance. How I would implement a control?

Avoid using parameter prompts. Use controls on forms for filtering
queries/reports/forms.

--
Duane Hookom
MS Access MVP
--

I'm trying to figure out how to make the results of one query be
available as a dropdown menu prompt for the criteria of another query.
Is there an easy way to do this/ I'm doing this to avoid typos, when
prompting the user for criteria with the [].


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************