Create a dropdown with room to add values to the drop down later

A

aadele03

i am making a table in access, with one of the fields having a drop
down menu. i want one of the values in the drop down to give a user the
ability to type in a new value into the drop down in case the value
wasnt in the drop down initially. how do i do that. It will be really
helpful cos i have been working on this for hrs. Thanks
 
J

Jeff Boyce

Step away from the computer!

If you are working directly in the table, using the Lookup datatype, you are
likely to cause severe headaches for yourself and any others who use your
application. And if you need to add a "new value", you are out of luck
entirely within the table environment.

Access tables store data, Access forms display it for review/add/edit.

First, check the newsgroup "tablesdbdesign" to see the consensus that Lookup
datatypes in tables is a "BAD THING". Then, after converting your Lookup
datatype field to a numeric datatype (I assume the "key" field is numeric),
take a look at Forms.

One of the many events in the rich Forms event environment is the NotInList
event, which triggers when someone enters a value not in the underlying list
into a combo box. A quick search on NotInList, including in Access HELP,
will reveal code to help your users add a new item ...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top