Dropdown List

[Craig]

I have created a database to track various information
across multiple departments and plants within my
corporation.

I have then created several queries to provide the users
with the information that they want based on the specific
plant and department that they are interested in.
Currently the query requests this information from the
user and they type it in. Ideally, the user would be able
to select the plant/department that they want using a
dropdown list. Is it possible to do this to a query box?

Thanks,
Craig

 

[Roger Carlson]

You have to create your own form to do this. On my website (see sig below)
is a small sample database called "ParaQuerySelect.mdb" which illustrates
one way to do this.