Full error message is The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'SREF'
The Main Form is for property insurance policy information and SREF is a number field unique to each property's policy. The subform is to add the contacts the renewal documents need to be sent to each year. There are sometimes multiple contacts for a policy and contacts often apply to multiple policies so I set up a separate table called 'Renewal contacts' to add a subform that contains just the fields to link the policy records to the contact records.
Link Master Fields: Policy Data.SREF
Link Child Fields: SREF
Query for main form has policy information from 'Policy Data' table and client code from table 'LivePolicyList' with relationship all 'policy data' and 'LivePolicyList' that match.
'Renewal_Contacts_Subform_Query' has 2 tables in it, the first 'Renewal Contacts' only has 3 fields in it, an autonumber primary key, SREF and Contact_iD (all number fields) and the second table is 'contact_data' which contains individuals contact data. The relationship is currently 'Contact_ID' in both tables with relationship of all 'renewal_contacts' and only 'policy data' that is equal. I have tried changing relationship to other options without success.