[AccessD] Change Order within Access 2007 Report Group - Thanks! Plus Bonus Puzzler

> Brad, I don't recall running into that, but it was years ago when I did
> it. The only difficulty I recall was working out the grouping levels -- I
> had about three in the works and getting the syntax right was a bear.
>

Susan H.


> This all works nicely, except for one thing.  In order to see the affect
> of either the Ascending button or the affect of the Descending button, I
> need to execute the same  line of code two times.
>
> Example -
>
> Me.GroupLevel(0).SortOrder = False      ' Ascending
> Me.GroupLevel(0).SortOrder = False      ' Ascending
>
>
> Things seem to always work nicely, when I do this, but I would like to
> understand why it appears to take two executions of this code.
>
> Any ideas?
>
> Thanks,
> Brad
>