Drop Down Lists

L

Larry G.

I have not done this for a long time and forgot how to do it on a table. I
think i should use the look-up Wizard but I am not sure. I want users to
select an item from a LARGE list of possibilities as they enter information
into the table, and ONLY one of those items. Any help is appreciated.

Larry
 
S

Sean Varano

Few options. On ACCESS XP choose the field type "Lookup wizard" then go
through the wizard. If it is a table, choose the table, etc.

If a previous version, choose field type text. In the field properties at
the bottom of the screeen choose the "Lookup" table, change those settings to
reflect the table and/or values you want to use.
 
D

Douglas J. Steele

You shouldn't be updating tables directly. Create a form, and put a combobox
on the form.
 
Top