Eureka! afte3r another two hours, I worked it out. Not even sure what I did except I created new controls for each field versus adding from existing ...

Okay, here is a working sample of the sorting function. Give it a whirl and let me know what you think. NOTE: You must extract the zip file to yo...

Here is the code I used. I used the same code for each button, making sure I edited each one appropriately. As you can see it works quite well. Enj...

My bad, I failed to set the On Exit to reorder AccCode. Here is my final version.  Final-Sorting-Code.mp4

All, Attached is a short video showing the process in action. I tried to emulate Excel sort mode as best as I could. Comments  2024-11-05_...

I think I have it figured out and it works…..added an On Exit sub routine that resets the orderby, icon and request the form. DoCmd.SetOrderBy "AccC...

Well, I made some progress and need help finishing this off. It works fine, but I am having a problem with making the cmd button picture returning to...

Forgot to address your last statement. I do have an idea floating in my head to automate and indication on the label to show which sort option is in ...

Interesting. Then maybe to help the user see what mode they are in, the icons could be faded until clicked. That way only the asc arrow, or the dsc ...

I do hope to see this forum become active in the coming day! 😎