Results 1 to 3 of 3
  1. #1
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936

    Multiple Subreports

    I have three nested subreports, all seem to be behaving very differently!

    After much trouble getting it right, the last problem I am having is the repeating as below - the line in red :

    subform1 heading
    subform1 detail
    subform2 heading


    subform2 detail
    subform3 (if there is data)
    heading
    detail
    detail
    subform2 heading
    subform2 detail

    How do I get the subform2 to behave correctly, to not repeat the heading for each detail line?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Is there a bound control in the Detail section that displays the Subform2 Header field? If you right click the detail, can you add a Header?

  3. #3
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Not sure what you're asking. Subreport2 (sorry, change all the above to "report", not form) is bound and I can add a page header.

    One of the problems I had earlier was that the report was showing even when there was no data. The solution seemed to be to add a nonsense group, on expression "1", so that is where the headings are - group header.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-16-2013, 03:44 PM
  2. Replies: 6
    Last Post: 04-04-2013, 05:32 PM
  3. Replies: 4
    Last Post: 01-25-2013, 01:57 PM
  4. Replies: 5
    Last Post: 05-18-2011, 11:02 AM
  5. Multiple Subreports with page break
    By rayc in forum Reports
    Replies: 7
    Last Post: 09-02-2006, 06:59 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