Hello All!
I have a report that is header grouped to each ID of my maintable to ensure that each entry in the table gets its own page in the report.The report gathers data from two places: 1) The main table 2) A List Box in thereport uses a query to list items from two other tables that are keyed to themain table.
I hope the above makes sense. Here is my issue: The maintable has 250 entries, which successfully generates 250 pages in report printpreview that each has the data that they should. However, the list box repeatson every page with the data that it should, but only from the first ID of themain table. (The list box on page 1 is correct, but the other pages are notbecause the list box repeats the data from page 1 on all of them).
The query for the list box uses the criteria that the secondarykey of another table needs to match the main table ID shown on the report page.Again, works good on the first page, but does not update the list box object onsubsequent pages.
Please help!
Thanks,
Kyle