sort when click buttons on form header

S

Song Su

I have a continuse form and underlined query as record source.

I want user to be able to click buttons on the form header to sort. I have
Last Name, First Name, Department, Phone etc. How to code these buttons?

Thanks.
 
S

scubadiver

If the source is a straightforward select query you can always use
right-click of the mouse (but have you disabled the menu?)
 
S

Song Su

I disabled all the menu for the form form. I want user to click buttons on
form header to sort so I need some kind of vba code

thanks.
 
Top