add data to table via a combo box

[JordanB]

Is there a way to add new data to a table if its combo box does not show what
the user wants? Example being: have a table that shows sheetrock but not
spackle. Want to add spackle to the table as well as use it in the form.

 

[John W. Vinson]

Is there a way to add new data to a table if its combo box does not show what
the user wants? Example being: have a table that shows sheetrock but not
spackle. Want to add spackle to the table as well as use it in the form.

Yes. Use the Combo Box's Not In List event. For sample code see

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