"MIKE" said:
I need help setting up a drop down list to choose from
when filling out a form. On my form I have several
categories that I input information. But on two of them
specifically I would like to be able to select from a list
instead of inputting names everytime. I have approx. 30
names that are used repetitively when filling out the form
for my access worksheets. Can drop down list be made for
the Form? Any help on this?
Mike
The way to do this is to create a lookup table that holds the values for the
list. You will probably want to have two fields in each table, one being an
Autonumber as a primary key so that the record can be uniquely identified, and
the other will probably be text. If the primary key for this table is an
autonumber, then you will need to make sure that the corresponding field in the
main table is Long Integer.
Next open your form in design mode.
Ensure that the Control Wizards are turned on, as this will help you with the
creation.
Next, select a Combo Box from the controls menu, and place it on the form where
required. The combo box wizard will appear, with three options.
Select the first option, to look values up in a table and press Next.
Select the name of the table with the lookup data in, and press next.
Select the fields that you want to have in the combo box, which will be the
primary key and the text.
Access will suggest that you hide the primary key column, so accept this, and
move to the next screen.
Select the field that you wish to store this value in.
Type a label for the control, and then finish.
Now when you open the form, you will have a combo box that allows you to select
from the list of values, and stores it in the table.
