Access 2010 - report with subreport - dynamically change sort order with a group
Posted on 2013-02-03
I have an Access 2010 report with a subreport. It lists jobs within division, then gives division totals.
The user selects the sort option (via a form). Within each division, the user can sort by date, job value, or job number.
The parent report just lists division totals. It is the subreport that lists the job details.
In the subreport I GROUP on division, to give me division header and footer for totals, etc.
How can I set the sort order programmatically if I use the grouping functionality of reports?