when bind to ID, while display the name, and you also want to allow
user to input new record, you need to code for the 'notinthelist' event.
in the event code, insert a new record into table, and then do the 'requery' to update the combo list.
This post has been archived. It cannot be replied.