Adding a value to a table from a form

  • 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?
 
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
Click to expand...
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?
 
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?
Click to expand...

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