Sort field by clicking on label 1

[air0jmb]

I want to be able to change the 'sort by' on a form by clicking on any field's label.

I'd like something similar to when using Windows, the clicked label sorts that field and displays an up/down arrow to indicate whether that field is sorted A-Z or Z-A.

Thanks!

Mike

 

[TheAceMan1]

How are ya air0jmb . . .

[ol][li]In the [blue]Tag property[/blue] of each label to control sorting enter the [blue]corresponding textbox control name![/blue][/li]
[li]In the code module of the for copy/paste the following:

[blue]Public Sub SortIt(Name As String)
   Me.OrderBy = Name
   Me.OrderByOn = True
End Sub[/blue]

Next in the [blue]On Click[/blue] of each label:

[blue]   Call SortIt(Me![purple][b][i]ThisLabelName[/i][/b][/purple].Tag)[/blue]

[/li][/ol]
Open the form and test . . .

See Ya! . . . . . .