Results 1 to 3 of 3
  1. #1
    kgoepel is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2017
    Posts
    4

    Error message in Subform 'The object doesn't contain the automation object'

    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.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Make sure that your main form query contains the field SREF only once. Then remove the table name from the Link Master Fields property.

  3. #3
    kgoepel is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2017
    Posts
    4
    Thank you so so much! Very much appreciated! Worked perfectly! I hope you have an amazing weekend

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 07-10-2015, 01:02 PM
  2. Replies: 4
    Last Post: 02-06-2014, 12:55 AM
  3. Replies: 1
    Last Post: 12-27-2013, 01:59 PM
  4. Replies: 1
    Last Post: 07-02-2013, 08:41 AM
  5. Replies: 3
    Last Post: 11-02-2010, 10:14 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums