Drop Down Lists

[Guest]

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

 

[Guest]

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.

 

[Douglas J. Steele]

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