Adding a value to a table from a form

[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?

 

[Van T. Dinh]

Check Access VB Help on the NotInList Event for the
ComboBox.

See also The Access Web article:

<http://www.mvps.org/access/forms/frm0015.htm>

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
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?

 

[John Vinson]

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?

Yes. You need some VBA code in the combo box's Not In List event to do
this. See

http://www.mvps.org/access

and search for "Not In List" for sample code.