I am using the attached database to generate a report and wanted to add a table of contents at the front.
I could not make that work, so I added an index at the back using a sub form:
The data for the subform is added to the table as the report prints, filling all the "elements" and their associated page numbers.
The process to populate the table works fine, but the CASp_ReportTableOfContentsRpt02172013 subform only prints a portion of the data. I'm not sure why that is happening. I've tried re-applying the data query and requerying the CASp_ReportTableOfContentsRpt02172013 subform but neither of these processes work.
Can you offer any suggestions? database is attached.