Report with "manual" table of contents

[bfamo]

Hello everyone!

I'm building a report with 5 subreports in it. Each of the 5 subreports is divided by a page break in between. The reason for using these subreports is that I have to include a lot of graphs in the report, and each of the subreports is based on different tables.

Now, I'm also going to need a table of contents. I've been reading up on the subject, and most of the forum posts and how-to guides gives more or less the same version as the KB131588 article.

Is it possible to build a static table of contents using text labels and some VBA code that can track the page number of a control such as subreport or a textbox?

Thanks!!

 

[dhookom]

I'm not overly optimistic there is a simple solution. You might want to consider using group by sections for your subreports and then try Printing First and Last Page Numbers for Report Groups.

Duane
Hook'D on Access
MS Access MVP

 

[bfamo]

thanks dhookom,

I'll try out your suggestion and post the result.

I initially tried to put a textbox (txtSub1, txtSub2 etc...) next to each subreport with control source "=[Page]". This gave me the page numbers I wanted. It was a long shot, but I tried to write some code that would copy these page numbers to my manual table of contents:

me.txtTocSub1 = me.txtSub1

The problem is that I have to run this code in the reports On_Format event, which is a bit too early.