Need help to create a push button to sort my fields 1

[Taecca]

I have a continuous form with a few different columns.
I wish to add a button at the top of each column for the user to press and sort by that column. I will then add a refresh to the code to display the newly sorted records.

Can that be done?

Thank you for your help

 

[FancyPrairie]

In the OnClick event of each of the buttons, add a call to a function passing it the name of the field you want to sort on. For Example,

On Click... =SortColumn("FieldNameToSortBy")

Function SortColumn(strFieldName as String)

Me.OrderBy = strFieldName
Me.OrderByOn = True

End Function

 

[Taecca]

WONDERFUL!
Thank you