Can I use a drop-down list from a table as source 4 a parameter qu

[venajoe]

I am in the process of building a "Equipment Service Request" database. I
want to create parameter queries that promptsusers for a value, say,
manufacturer, but I want the user to select from a drop-down list whose
values are stored in a table instead of typing in the desired value. Can
this be done?

 

[venajoe]

Jeff,

I appreciate your prompt response. To date I have only used forms for
inputting data into tables, but I will experiment and see what I can come up
with. Thanks for pointing me in the right direction. One more general
question about Access 2003. I have taken the online training courses, and I
am taking as many Access 2003 training courses at work as I can. What's the
next step for going deeper? I have rudimentary knowledge of most Access
objects, but would like to grow in the confidence that I'm not doing things
the hard way. Help! Thanks again.

Joe

 

[Jeff Boyce]

Use a form.

Access forms are for displaying data (and data entry/edit).

Look for "combobox" in Access HELP, or as a topic in a tutorial.

Instead of a parameter query (which can only provide the prompt), using the
combobox in a form lets you control what the user sees/selects.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/