I have a form - frmSuppliers - on which is a sub form - frmContacts. I have a button - btnFindContact - on the Contacts sub form to find a ContactSurname. When frmContacts is opened independently (when I know the name of the contact but not the name of the Supplier he/she works for) and I search for (and find) a contact I would like the Contact form to close and the Supplier form to open displaying the record which has the relevant contact. Is this possible?
The link child, link master field is SupplierID.
Any help would be greatly appreciated.
The link child, link master field is SupplierID.
Any help would be greatly appreciated.
