I have two Forms.
An Address Data form maintains Address Data and is associated with an Address Table with a field called ADDRESS_KEY.
A Member Data form maintains Member Data and is associated with a Member Table that includes a Member Address Key field called ADDRESS_KEY. This field uses a Combo Box to lookup / assign the desired ADDRESS_KEY from the Address Table.
This works without any problem.
On the Member Data form there is a Button to open the Address Data form to add new addresses.
The problem I have is that after adding a new address in the Address Data form and saving it, when I go to the Member Data ADDRESS_KEY Combo Box I can't 'see' the new Address Key to select it unless I close and re-open the Member Data form. I don't want to do this.
How can I make the newly added Address available immediately in the Member Data Address Key Combo Box?