Sort records on a report

[twixx]

Hello!

I'm trying to sort the records on a report by allowing the user to select different ways to sort. The code I have right now will only sort the records one way, not the other. Can someone help me please?

 

[pbaldy]

One way:

Private Sub Report_Open(Cancel As Integer)
  Select Case Forms!frmReports.fraGrouping
    Case 1
      Me.GroupLevel(0).ControlSource = "CarType"
      Me.txtGroup.ControlSource = "CarDesc"
    Case 2
      Me.GroupLevel(0).ControlSource = "Company"
      Me.txtGroup.ControlSource = "Company"
    Case 3
...