Results 1 to 4 of 4
  1. #1
    OllieCat is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    1

    Link main form to subform

    Hi. My first post. Hope someone can help me understand this. Still learning with Access!



    So I have a main form called RequestsF with RequestID and I have a continuous subform called sfrmSource. There are 5 records in the subform that I want to be visible for every record of the main form. I've done this bit. The problem is when I enter data on the subform it remains the same when I click through records on the main form. When I set the Link Master and Child fields to RequestID all the records vanish from the subform.

    I've attached an image of the form - it's the status tab that has the subform with the records e-book, load to learn fields etc.

    Any help would be much appreciated.

    Thanks.
    Attached Thumbnails Attached Thumbnails Requests Database.jpg  
    Last edited by OllieCat; 05-12-2017 at 04:56 AM. Reason: Change picture

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is there a RequestID field in the record source of the SubForm?

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    welcome
    is this what you want ?
    Attached Files Attached Files

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    This appears to function as I would expect. It also does not match your posted screen shot so I don't know what issue you are having.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-06-2014, 05:35 AM
  2. Replies: 3
    Last Post: 01-05-2012, 07:15 PM
  3. Link main form with subform
    By lizzywu in forum Forms
    Replies: 1
    Last Post: 11-18-2011, 03:22 PM
  4. Replies: 3
    Last Post: 11-16-2011, 01:56 PM
  5. Replies: 2
    Last Post: 08-01-2011, 11:35 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