Results 1 to 2 of 2
  1. #1
    AccessNewb11 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    23

    Error entering new record on a subform

    Hi all!
    I am having a problem with my Contacts Database. I have attached it for your review.
    On my main form entitled "frmContact", I have a form to enter a new contact. I have a Notes subform, and I want to be able to enter multiple notes for one person. I have a note for John Doe, and tried to enter a new note for him and got this error message:

    "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblcontact"."

    Please help!
    Thank you so much in advance!
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    It's possible in your relationships is in error. You currently have COMPANY and CONTACT in a 1 to 1 relationship. Which means only 1 person per company.
    Its possible 2 people could work for the same company and may cause validation error.

    I tend not to use these kind of relationships..ONLY vital ones like:

    tOrder - tOrderItems
    or
    tPerson - tPersonPhones

    ...the 1 to many tables rels. that MUST exist.

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

Similar Threads

  1. Replies: 8
    Last Post: 11-26-2013, 12:21 PM
  2. Replies: 1
    Last Post: 11-21-2013, 12:17 PM
  3. Replies: 14
    Last Post: 08-01-2013, 09:46 PM
  4. Error on entering duplicate value
    By anwaar in forum Programming
    Replies: 3
    Last Post: 09-02-2011, 01:25 PM
  5. Replies: 4
    Last Post: 04-07-2011, 03:39 PM

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