Applying Report's Sort Order via code

  • Thread starter Thread starter TBernard
  • Start date Start date
T

TBernard

I got great help here in the past with some code to sort
my report through code, depending on choices a user makes
on another form. Here is the code that I currently use
and works correctly:

Select Case Forms!frmOpenIssueReport.frameOrder.Value
Case Is = 1
Me.GroupLevel(1).ControlSource = "MainIssueID"
Case Is = 2
Me.GroupLevel(1).ControlSource = "IssueName"
Case Is = 3
Me.GroupLevel(1).ControlSource = "IssueDate"
Case Is = 4
Me.GroupLevel(1).ControlSource = "Category"
End Select

This is placed on the Open Procedure of the report and
works great. Now the users want to be able to sort the
report by either Ascending or Descending. I have been
playing with the code but have not found a way to do
this. I tried Me.GroupLevel(1).SortOrder but it only
allows True or False.

If anyone has any ideas it would be greatly appreciated.

Thank you,

TBernard
 
TBernard said:
I got great help here in the past with some code to sort
my report through code, depending on choices a user makes
on another form. Here is the code that I currently use
and works correctly:

Select Case Forms!frmOpenIssueReport.frameOrder.Value
Case Is = 1
Me.GroupLevel(1).ControlSource = "MainIssueID"
Case Is = 2
Me.GroupLevel(1).ControlSource = "IssueName"
Case Is = 3
Me.GroupLevel(1).ControlSource = "IssueDate"
Case Is = 4
Me.GroupLevel(1).ControlSource = "Category"
End Select

This is placed on the Open Procedure of the report and
works great. Now the users want to be able to sort the
report by either Ascending or Descending. I have been
playing with the code but have not found a way to do
this. I tried Me.GroupLevel(1).SortOrder but it only
allows True or False.
Click to expand...


You're on the right track, True is for Descending, False fo
Ascending.
 
Back
Top