If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do you make a drop down list in Access field?
setting up fields and would like drop down lists rather than typing in same
information constantly |
#2
|
|||
|
|||
how do you make a drop down list in Access field?
Tim,
See Help under "Combo boxes" Combo boxes allow the user to select a value, from a list of values... provided by a table, a query, or a manually entered value list. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "timv" wrote in message ... setting up fields and would like drop down lists rather than typing in same information constantly |
#3
|
|||
|
|||
how do you make a drop down list in Access field?
You posted in a newsgroup devoted to supporting Microsoft Access tables and
db design. If you question concerns doing this ("drop down lists") directly in tables, DON'T! Although Access offers "lookup" data type in more recent versions, you (and those who need to maintain the app after you) will find it is "high maintenance". The preferred approach is to use the appropriate data type for the primary key of the looked-up table (?long int?), then use FORMS to hold comboboxes (drop-downs). Do the looking up, by all means, but do it in forms, not in tables. Access tables store data, Access form display it. Regards Jeff Boyce Microsoft Office/Access MVP "timv" wrote in message ... setting up fields and would like drop down lists rather than typing in same information constantly |
#4
|
|||
|
|||
how do you make a drop down list in Access field?
On Wed, 25 Feb 2009 08:59:01 -0800, timv
wrote: setting up fields and would like drop down lists rather than typing in same information constantly Use a Form - NOT a table datasheet!!! - to enter your data, and put a Combo Box control on the form. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|