combo boxes not in list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that already has a control source. It also has a row
source, which populates the drop down. The combo box only shows one column
in the combo box, but there are actually two columns. When the user selects
a number from the combo box, a text box on the form populates data from the
second column of the combo box. When the user enters a number that is not in
the combo box, a message box asks the user if he/she wants to add the number.
The problem I am trying to figure out is, once the user enters a number not
in the list, I want the user to enter the data in the text box on the form
and to update the combo box with that data that was just entered into the
text box. I hope this doesn't sound too confusing.
Can someone help me? Thanks.

Ashley
 
The answer depends on the row source type. If it is a table or a query based
on the table, then once you complete entering the new data, requery and it
will be in the combo list. If it is a list, then you will have to use VBA to
modify the rowsource list as you would modifying any object property.
 
Back
Top