Results 1 to 3 of 3
  1. #1
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52

    How to solve this subform issue?

    Hi,



    I have a form with a subform in it. The source for the form is table A. The source for the subform is table B.

    I want to create multiple records in table B (subform) for a single record in table A (form). When I try to do this it returns an error regarding duplicate records in table A.

    Is it because that when the record in table B is saved it also tries to save the already created record in table A? Thereby having duplicate records? How can I get around this?

    Thank you very much!

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Most likely it's an issue with how you linked the two forms together. See what you have in the Link Child Fields and Link Master Fields properties of the Subform.

  3. #3
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52
    YES! That was were the bug was.

    Thank you very much!

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

Similar Threads

  1. Subform Link Issue
    By danhartman in forum Forms
    Replies: 7
    Last Post: 07-06-2010, 07:14 AM
  2. can you solve my problem please?
    By grad2009 in forum Access
    Replies: 2
    Last Post: 02-16-2010, 05:02 PM
  3. Subform scrolling issue
    By Jerry8989 in forum Forms
    Replies: 4
    Last Post: 12-08-2009, 01:12 PM
  4. Subform Data Entry Issue
    By yuriyl in forum Forms
    Replies: 3
    Last Post: 05-14-2009, 08:49 PM
  5. command button to filter a subform issue -
    By countdrako in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 11:58 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