You should check out this link: http://www.yqcomputer.com/
It is pretty much right down the line of what you're looking for I believe.
It does limit you to entering only the one value you type in the comboBox
that would perform the lookup of other records. It may be possible to input
multiple values into a new record if you could somehow break up the NewData
string variable in the NotInLIst event. You can also avoid using the primary
key number by setting the width of that first element to 0" in the
properties, or dragging it all the way to the left in the comboBox creation
wizard. Then you can use the value of the second column instead.
Hope this helps!