Set Sorting + Grouping in VBA code ???

D

David

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!
 
A

Alphonse Giambrone

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

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