Combo box - adding value to a table

[jdembosky]

I have a form with fields that pull from a table. I would like to be able to either pull a value from a list ( a combo box tied to a table - I have gotten this to work) or enter in a value that is not in the list/table. When I enter in a new value, I would like it to be added to the table, and thus be able to access it from my combo box for future entries. Is this doable

 

[Allen Browne]

If the combo box is adding just the value you type (not an autonumber as
well), you can use the Not In List event to add the new data to the combo's
RowSource table.

Details:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a form with fields that pull from a table. I would like to be able

to either pull a value from a list ( a combo box tied to a table - I have
gotten this to work) or enter in a value that is not in the list/table. When
I enter in a new value, I would like it to be added to the table, and thus
be able to access it from my combo box for future entries. Is this doable?