Combo Not in lIst causes duplicate records (1 Viewer)

[kfschaefer1]

I have a mainform/subform. Combo for Vendor Name is on subform.

If the user needs to add a new Vendor name, I use the Liimit List Edit form - allow the user to add a new vendor. however, when the user returns to the Mainform/Subform to continue to enter the invoices, it does not set the record to the new vendor (the data is updated in the tblinvoices for list of vendor Names per contract) It wants to create a new record, causing duplicate paritial record for the Vendor and the new record that the user input the remaining Invoice detail.

Note: I also tried using various versions of the NotInlist, but I don't think that is where the issue lies, I need to be able to set the cbovendorName to go to the record that was created in the Invoice table when I added the new Vendor Name, instead of allowing the user to create a new record.

If when I return to the mainform/subform and hit ESC & F5 then the invoices have been updated to reflect the newly added Vendor in the list of invoices, waiting to be edited.
See attached.