I am really struggling with an issue which I am sure someone can fix for me.
I have prepared a simplified database (attached) that should show the problem.
The database as it is at the moment has 2 objects (Groups and Contacts)
A group can have a contact assigned, but only those that are designated as valid for that group.
When creating or editing a group, the contact is selected from a ComboBox. In the case of a new Group, the ComboBox would of course be empty. So there is a “New Contact” button that allows to add a new contact for the group. In the case of editing a Group, there is also a requirement to add a new contact, so the New Contact button is also required there.
I am not using the ComboBox option “List Items Edit Form”, because this application needs to work under Access 2003 as well.
My problem is that, when the frmAddMainContactToList closes (using the Save button) the comboBox on the main form is not populated with the new ContactID and the subform showing the contact details is not refreshed.
I hope this is a clear enough explanation.