Results 1 to 3 of 3
  1. #1
    Ganymede is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2011
    Posts
    116

    Pagebreak between report and subreport

    I want to generate an invoice that has a (1) cover page with a summary of the amounts being billed, and (2) a support page showing the calculation of the billed amount reflected on the cover page. I have created a report that is bound to a query with (1) the summary of the amounts being billed, and a subreport that is bound to a table to show (2) the support for the calcualtion of the billed amount.



    I placed the subreport in the footer section with a page break immediately before it. But that did not make the subreport start on the second page. I'm not sure what I need to do to pull this off. I would appreicate any guidance.

  2. #2
    Ganymede is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2011
    Posts
    116
    Please disregard. I figured it out. I used group and sort, put the subreport in the group footer, and set the "Force New Page" property in the group footer section to "before and after."

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Just mark it as solved then. Top right of thread.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 5
    Last Post: 02-13-2024, 07:22 AM
  2. Replies: 5
    Last Post: 05-11-2020, 01:13 AM
  3. Replies: 1
    Last Post: 01-10-2020, 05:56 PM
  4. Replies: 2
    Last Post: 03-09-2015, 01:06 PM
  5. Replies: 1
    Last Post: 04-15-2013, 10:02 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