I have a chain of three synchronised combo boxes - cboProductCategory links to cboSupplierName links to cboSupplierContact. The links all work fine, but I would like to use the Not In List event on the Contact name, so that users can add a new contact name if need be.
Once a supplier is selected, the relevant contact names for that supplier can be chosen from the cboSupplierContact, but this combo gets the names from the fields ContactFirstName and ContactSurname and concatenates them in the combo box.
How do I "unconcatenate" them when sending new records to the table via the combo box. I want the users to be able to simply enter "Fred Bloggs" in the combo but for "Fred" and "Bloggs" to be sent to their appropriate fields for the appropriate supplier.
Any help would be gratefully received. This kind of stuff is out of my league I'm afraid.
Rob
Once a supplier is selected, the relevant contact names for that supplier can be chosen from the cboSupplierContact, but this combo gets the names from the fields ContactFirstName and ContactSurname and concatenates them in the combo box.
How do I "unconcatenate" them when sending new records to the table via the combo box. I want the users to be able to simply enter "Fred Bloggs" in the combo but for "Fred" and "Bloggs" to be sent to their appropriate fields for the appropriate supplier.
Any help would be gratefully received. This kind of stuff is out of my league I'm afraid.
Rob
