Sort order Descending and Ascending

[Tcurtis]

Hi, I have a form that my user wants to sort by ascending and descding order. They would like to click on the field title in the header of the form and switch from descending to ascending and back again. Is that a way to do this with VBA? I am very new to VBA and do not have a good grasp on it.
Thanks

 

[xenou]

It might be possible, but better just show them how to right-click in the field and choose sort from the right click menu. This has the advantage of 1) already being done for you and 2) the user can do this with almost any form, query or table so they get to learn to fish rather than just getting a fish.

 

[Tcurtis]

Thanks. This is what the user is asking for. The user is asking to be able to sort by descending or ascending order with the click of the header label. They have also asked for the ability to filter by a couple of fields.