How to disable or change the report Sort option in Access 2007 using vba
Posted on 2013-05-15
I have a report where under the Group and sorting options I have only one sort option selected. No grouping. I want to use this report for another means and need to be able to either remove that Sort in the report open event or at least change the field that the report is sorting on. I can do this for Groupings, but cannot find any code for a sort only. the OrderBy has no effect. Trying to access GroupLevel(0) returns an error. Any ideas on how I can change this sort using vba?