title: Access VBA - OrderBy with multiple field
body: <p>I wonder how I should do this. Actually, I have some subform and, by clicking on the title, I want the recordset of this subform to orderby. This is an example of what I do:</p>
  
  <pre><code>Private Sub sigle_cours_Label_Click()
      If (Me.OrderBy = "COU.sigle_cours") Then
          Me.OrderBy = "COU.sigle_cours DESC"
      Else
          Me.OrderBy = "COU.sigle_cours"
      End If
      Me.OrderByOn = True
  End Sub
  </code></pre>
  
  <p>My problem is this one : I want to OrderBy with sigle_cours AND num_cours but it don't work. I try this but there's no way to sort by DESC :</p>
  
  <pre><code>Private Sub sigle_cours_Label_Click()
      If (Me.OrderBy = "COU.sigle_cours,COU.num_cours") Then
          Me.OrderBy = "COU.sigle_cours DESC,COU.num_cours DESC"
      Else
          Me.OrderBy = "COU.sigle_cours,COU.num_cours"
      End If
      Me.OrderByOn = True
  End Sub
  </code></pre>
  
  <p>How should I do this?</p>