sort when click buttons on form header

[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.

 

[scubadiver]

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

 

[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.

 

[Joan Wild]

See
http://groups.google.com/group/micr...76cc4/46ba1e51b90ba26f?tvc=1#46ba1e51b90ba26f