Updating a combo box after updating the table the combo box queries

[Goaltender]

I have a payment form (subfrmJoinGroupTraining) that I use to enter payment details. I have a combobox called 'Institution' that when a user types in a new entry the 'not in list' event triggers the 'frmInstitution' form to open so the user can enter the new institution information.

I am aware of how to work with the 'not in list' event. I need help with the remaining post.

I want the new entry that triggered the 'not in list' event to be put into the field 'InstitutionName' on the 'frmInstitution' form.
When the remaining address fields are entered into the 'frmInstitution' form there is a command button to close the form and set the focus on the combobox 'Institution' on 'subfrmJoinGroupTraining'. I want the combobox to have the newly entered institution so the user can move the focus to the next field without triggering the 'not in list' event again.

Thanks to all that reply,



Jim
"Continually learning.....rather be fishing!"

 

[ALEKSJAY]

when you update the information for that combo box, call the comboBox.requery Method. Or call it on the OnGotFocus event of the combo box