No Not In List

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a combo box that has a list of employees names. I
want to be able to update it without actually having to go
to the table and edit from there. I was told to go to
the On Not in List event under properties, but I am
stuck there. I searched the net for something pertaining
to this, but nothing was produced. Can someone help me
out with some code perhaps or a macro that might work here.

Thanks,

Frank
 
If you put this under the not in list event for the combo box it should add
the value to the list (and set it to that value).

Private Sub Combo2_NotInList(NewData As String, Response As Integer)
MsgBox "That value is not in the list. I will add it.", vbOKOnly
Combo2.AddItem (Combo2.Text)
Combo2.Value = Combo2.Text
Response = True
End Sub
 
Back
Top