Hi,
I have a combo box cboPublisher on a form frmBooks, with an event procedure for (On Not In List), if value entered is not in the list then a message box appears asking the user if he wants to add this value to the list with a vbYesNo + vbQuestion.
If yes button is pressed, a form frmPublishers is oppened asking to add the new publisher to the table of publishers (tblPublishers). This form has two fields: publisher field (txtPublisher) and city field.
How can I have the value the customer typed in the combo box (cboPublisher) to be copied to the publisher's field txtPublisherName in frmPublishers so that I do not need to type the value a second time.
Khalil