Referencing Access Report FIelds on Other Than Page 1
For reasons, in the Open or Load event of an MS Acess 365 report, I need to get each of the field values in the report (each of which is generated using complex calculations in its Control Source) and store them in a table. While I can easily reference a field on the first page of the report (e.g., Me!Text123), I don’t know how to reference fields on the other pages, using something like Me!Page(2)!Text123. Or, if that is not possible, how to programmtically move to the next page and then reference the field on that page.