Can I create a drop down menu in an Access table? How?

J

JHart

I have some columns in my table that contain a specific range of data. Can I
create a drop down menu from within that table so I can select my input and
not have to type it or can drop downs only be created in forms? I haven't
done this since using Office97 and can't find what I need. Thanks for any
help.
 
J

John W. Vinson

I have some columns in my table that contain a specific range of data. Can I
create a drop down menu from within that table so I can select my input and
not have to type it or can drop downs only be created in forms? I haven't
done this since using Office97 and can't find what I need. Thanks for any
help.

You can... it's called a "Lookup Field".

But DON'T. It's a mess, and will cause far more confusion and annoyance than
benefit. See http://www.mvps.org/access/lookupfields.htm for a critique.

Instead, use tables for their intended purpose - storing data - and use a
simple Form based on your table for interaction with the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top