Set Sorting + Grouping in VBA code ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 reports that are identical, one sorts Asc, the other Desc

Can I set the sorting/grouping in code so I only need one report??

Access help was no help!
 
In the report's open event:
'To sort ascending
Me.GroupLevel(0).SortOrder = False

'to sort descending
Me.GroupLevel(0).SortOrder = True
 
Back
Top