I have a form "frmCalls" with a ComboBox "cboContact". Next to the ComboBox is a command button "cmdAddContact" which opens a form to add a contact not in in the ComboBox.
on the Form "frmAddContact", I have an OK button "cmdOK" which saves the new contact details and closes frmAddContact.
I want "cboContact" on "frmCalls" to include the new contact I have added through "frmAddContact". So basically, when I click "cmdOK" on "frmAddContact", "frmAddContact" closes and requeries the list in "cboContact" on "frmCalls". I do not want to requery the whole form as "cboContact" is halfway down the form and I don't want users to have to re - fill the fields above.
I hope this makes sense. Thank you in advance.