help with sort button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. Can someone help
please?
Thanks, Edward Keith
 
edward said:
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.
Click to expand...


Use code in each button"s Click event procedure:

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