Results 1 to 4 of 4
  1. #1
    rwest is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    5

    Adding records with subforms

    Hello I Have created a form with multiple subforms in it. whenI try to created a new record using the subforms I get the error " Cannot add record(s); join key of table <name> not in result set. (Error 3348)". If someone could help me fix this it would be greatly apperciated. Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Must have to do with table relationships and the form/subform design. Can you provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rwest is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    5
    No I am afraid I can't do that. Is there something I could try or somewhere I should look to fix it?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    The issue is too obscure for me. Not an error I have encountered. Need to analyse project. Sounds like trying to add record when a required related record in another table not yet created.

    Why can't? Don't need real data, it is structure I need to analyse. Make copy, remove confidential data, run Compact & Repair, zip if large, attach to post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. adding records
    By jwallace203 in forum Forms
    Replies: 3
    Last Post: 07-18-2011, 10:00 PM
  2. Subforms and unwanted duplicate records
    By Del Coro in forum Forms
    Replies: 5
    Last Post: 02-24-2011, 03:16 PM
  3. Replies: 10
    Last Post: 01-10-2011, 07:52 PM
  4. Adding Records
    By Rick West in forum Forms
    Replies: 7
    Last Post: 05-17-2010, 02:31 PM
  5. Adding of Fields in Different records
    By pcliaros in forum Queries
    Replies: 1
    Last Post: 03-17-2010, 02:31 AM

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