I'm working with multiple report pages, each of which contains memo fields with lengthy responses. My ultimate goal is to create a master report that contains all of the "pages" in one report so that the detail for each record prints as collated pages. Because of the memo fields, the number of pages needs to be flexible. I'm able to get three of the original report pages into one report (working perfectly with collation) before I hit the 22" height limitation.
Is there a way for me to build the master report usiing "building blocks" or buttons that reference VBA code for each of the original reports? Like a section that says "insert report A here," "insert Report B here," and so on?
Or does anyone have any other suggestions? Your help, as always, is GREATLY appreciated!!