Hello,
Can someone help me with the following VBA? I'm trying to toggle a column ascending or descending when the toggle is clicked. I would like to add this to each of my tabular column form so users and sort as they wish.
This is what I have so far.... My Column that I'm trying to sort is OrderNum
If Toggle102.Value = True Then
DoCmd.SetOrderBy OrderNum, DESC
Else
DoCmd.SetOrderBy OrderNum, ASC
End If
End Sub
Thank you for your help!