Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Provided Answers: 1

    Unanswered: Main and Subform - Main Won't Update

    Hi Everyone,

    I have a two tables - One is Prospecting and the other is Call Log which tracks the result of prospective calls
    The Table for Prospecting has Indexes with Unique values such as phone number and street and Stores the Prospect info
    The Form for Prospecting contains a subform of Call Log

    The problem is when I want to update the Call Log Subform, an error is displayed for the Mainform Prospecting because it is seeing the same data on the mainform as what is in the table so it thinks the data is duplicated and wont let me save the Main form or the subform.

    How do I create a new record in the subform without Access thinking the data in the parent form is duplicated?
    I just want to update call results for the prospect. I tried Setting DataEntry to Yes but obviously I get a blank Parent form and blank subform.

    Thanks for all your help

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 5
    How are the Child subform related to the Parent Main form

    did you use the

    Link Master Fields
    Link Child Fields
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  3. #3
    Join Date
    Apr 2015
    Provided Answers: 1
    Hi Myle,
    To be honest I am not that experienced and have tried using the Master and Child field linkage in design view but have always had trouble understanding how to do it. Could you give me an example by any chance...The bit I don't understand is which fields to link and how to determine which would be a master field and which would be a child field. In other words, do both tables need to have the same fields -
    ID;ID and Prospect Last;Prospect Last??

    Thanks for your patience and help.

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