Drop Down List

[Aurora]

I am using Access 2003
I have a form that is based on "Department Names" of which there about about
12 different departments. In the query of the form, in the department field,
I added the statement, [Enter the Department Name]. Now I would like change
this to a drop down list of the department names so that the user can pick
the name instead of trying to spell it correctly. How can I do this? Can
someone tell me or at least point me in the right direction?

Aurora

 

[scubadiver]

Why not have a combo box in the form and use that as the source for the
query. After every time you choose a different department the records update
themselves.

 

[Cheese_whiz]

Hi Aurora,

Use the combo box (control) wizard in the tool box. That can handle most
common situations.

If you open your form in design view, then choose view>toolbox (ctrl-v then
x), a small window will open (the toolbox). It is a window with several rows
of buttons. In the top row there are only a couple of buttons. If you hover
over the right one on the top row, it should say 'control wizards'. Make
sure it's selected.

Then, in that same toolbox window, find the 'combo box' button and press it.
Now, back over in your form, left click and hold where you want to put your
combo box.....drag out a small rectangle the size you want your combo box to
be, and then release the left mouse button. The wizard should open up and
walk you through the process.

The first screen is where you choose what you are using your combo box for
in the form. You weren't overly clear about that in your question. If you
are using the combo box to select a department value that will become part of
a new record, then choose the first option. If you want to look up an
existing record based on the choice made in the combo box, use the third.

HTH,
CW