Results 1 to 5 of 5

Master and Child Field Links for Sub-report Not Working

  1. #1
    plengeb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    20

    Angry Master and Child Field Links for Sub-report Not Working

    Hello,



    I have a database in which it have a sub-report within a report. The main report is “rpt_detail Overpays”, has the overpayments and blue headings. The sub-report is “rpt_LegitClaims”, has the legitimate claims and yellow headings. I am attempting to link the two reports (Master and Child fields) with the “Monthly_Sequence”.

    I have attached a sample of the report. The “Report Without Links” file has the results without the Master and Child field links. For each overpayment, all of the legitimate claims print for each of the overpayments as would be expected. I would like for the legitimate claims with a monthly sequence of 3954 to print with the overpayment with a monthly sequence of 3954 and so on. When I put the links in, the legitimate claims sub-report does not print any results with the overpayments. The “Report With Links” has these results.

    I have tried establishing relationships between the tables as well, but the links are still not working. Is someone able to tell me why the master and child links are not working and tell me how to get them to work?

    Thanks for your help.

    Bill
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,073
    Linking might not be the issue. Might need to create a group section on the MthSeq field.
    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
    plengeb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    20
    June7,

    You are right that linking was not the issue. I had to put a text box bound to Monthly_Sequence in the main report section containing the subreport? Thanks for responding.

    Bill

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,073
    Issue resolved?
    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.

  5. #5
    plengeb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    20
    Yes. The issue is resolved. Thank you.

    Bill

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

Similar Threads

  1. Replies: 3
    Last Post: 12-12-2012, 01:13 AM
  2. Replies: 5
    Last Post: 03-23-2012, 11:40 AM
  3. Replies: 1
    Last Post: 02-20-2012, 01:59 PM
  4. Master/Child between Subforms
    By Pilotwings_64 in forum Forms
    Replies: 3
    Last Post: 08-22-2010, 01:45 AM
  5. Link Master Field and Link Child Field
    By evander in forum Forms
    Replies: 2
    Last Post: 05-25-2010, 09:13 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
  •  
Tech Forums: Microsoft Office Forums