Hi,
I want to use the following code,
to sort the records from a field value,
but it not work!
Please help to fix it!
I want to use the following code,
to sort the records from a field value,
but it not work!
Please help to fix it!
Code:
Private Sub Report_Open(Cancel As Integer)
If Me.E = "1" Then
DoCmd.SetOrderBy "C ASC, A DESC"
Else
DoCmd.SetOrderBy "C DESC,"
End If
End Sub