Sort by 2 fields

[Anne]

I have put text boxes above a continuous form and for the date using the
following code
Private Sub TransDate_Label_Click()
If Me.OrderBy = "TransDate DESC" Then
Me.OrderBy = "TransDate"
Else
Me.OrderBy = "Transdate DESC"
End If
Me.OrderByOn = True

End Sub

I have another text box above the transactionID to sort by transaction type.

I need sort by transaction type, by date or date by transaction type.

I know I can set it up in a query, but then I cannot change back and forth.
Is there a solution?

 

[Jeanette Cunningham]

You can supply a combo or option group for sorting options.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia