Combo box - adding value to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.

jdembosky said:
I have a form with fields that pull from a table. I would like to be able
Click to expand...
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?
 
Back
Top