sort fields in continuous form

[eugzl]

I created continuous form where one of the field is date value field. I would like to create sort option by click header label of the field. I will appreciate if someone will show how to create code to sort fields of continuous form.
Thanks

 

[arnelgp]

see this demo.

 

[eugzl]

see this demo.

Hi arnelgp. Thanks for reply.
This is a very useful and interesting example. I will try to understand this code. But is it possible to create two toggle buttons in the field header label like in your sample? A one of the button with a triangle up and another with a triangle down. If you click on the button with the triangle up, the continuous form will be sorted in ascending order, and if you click on the button with the triangle down, it will be sorted in descending order. Is it possible to hide the appearance of the dialog filter launched by the DoCmd.RunCommand acCmdFilterMenu command. As I noticed, if you click on one of the continuous form fields and then from the Home Ribbon menu, click Sort Ascending or Sort Descending, the same operation will be performed. If possible to run sort using only VBA code? If that is possible. Can you show code how to do this?
Thanks

 

[Gasman]

This DB by @isaldogs sorts by headers asc and desc on a each click, but shows which by text.
You could modify that perhaps?