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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Cannot sort a table containing text 5
VBA sort code DESCENDING 4
Remove Identical words 0
Change GROUPING programmatically in reports 3
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Sorting sections or group sections 1

Top