I need to add items to a combo box that is bound to a single-column table through the On NotInList event procedure. I know how to add a value to a ValueList RowSourceType, but not to a Table/Query RowSourceType. The user input is all the required fields.
QUESTION: what is the VB code to save the new record in the single column table, and then requery the combo box to display the new value?
