I have set up 3 combo boxes on a form. They are based on a value list, not a table or query. I have set the limit to list property to Yes, and put the following code into the OnNotInList Event:
Private Sub AgtType_NotInList(NewData As String, Response As Integer)
Dim ctl As Control
' Return...