Combo Box

  • Thread starter Thread starter KP
  • Start date Start date
K

KP

I have a combo box on a form I use to complete entries in
a table. Is there a way to add a new item in the table
used by the combo box through the combo box on the form?
I've tried typing the entry in the combo box but it does
not appear in combo box table. It appears in table data
is used to support the form. I could use another button to
bring up table to add the new item in but thought there
may be a better way.

Thanks in advance.

KP
 
You have to put code into the comboBox's NotInList
eventHandler. Depending upon the complexity of the table
into which you are trying to insert the new data, this code
may be a simple SQL Insert statement or a call to open
another form.

Hope This Helps
Gerald Stanley MSCD
 
Hi Gerald and thanks.

I created a macro to open a form to type in a new entry
for the table; however, when I type a new entry in the
original form, the data remains in the table of this form
but is not added to the table the ComboBox is based on. Do
you have a clue as to what I am doing wrong?
 
If the macro is called from the comboBox's NotInList
eventHandler, have you set the Response to acDataErrAdded?
If you are still having problems, please post the code from
the eventHandler to this thread.

Gerald Stanley MCSD
 
Back
Top