Re: help with sort button

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

edward keith wrote:

>I have a form that shows all records on the screen at the same time. On My
>Header I put buttons over every column. I would like to make it if I click
>on a button above a column it will sort by that column.


Use code in each button"s Click event procedure:

Me.OrderBy = "fieldname"
Me.OrderByOn = True

--
Marsh
MVP [MS Access]
.

Quantcast