I have a 2-page report that includes a sub report that may have as many as 50 entries (records). The problem I am having is that the report wants to print 1 copy for each of the records in the sub-report. I can solve that by using the vba command "DoCmd.PrintOut acSelection, 1, 1" and it only prints 1 time. This issue is that if I have more than one page of records in the subreport, it won't print the send page of the main report. Looking for some answers. I have some experience with VBA, but would still consider myself a novice.
Subreport prints a page for each record (1 Viewer)
- Thread starter Laser1962
- Start date
No there is no force new page on the main report form. I apologize this is a single not a 2-page report. There is data above and below the subreport. If there are more than 26 records in the subreport, the data at the bottom of the page wont be printed using the vba code i mentioned before.
Minty
AWF VIP
- Local time
- Today, 05:45
- Joined
- Jul 26, 2013
- Messages
- 10,366
You would need to move that data into the page footer to force it to print on every page.
Without seeing what you have and what you expect it's a little difficult to visualize.
If you could post up a sample picture or preferably a sample database that would assist.
Without seeing what you have and what you expect it's a little difficult to visualize.
If you could post up a sample picture or preferably a sample database that would assist.
