Had to change the 1 to a 0 to count "Not Invoiced" worked great. I actually went to a level in my sandbox project of creating a separate query for ea...

Nice to see memberships growing.

Yep, Customers is a copy from Suppliers, so I do not know what is intended to be shown on that form. Suppliers looks like we have to wait for invoici...

I have to laugh, otherwise I will cry. I did create a q_Orders using the SQL that you used as the record source for the form and it worked. Can I ju...

Thank you Ursh, I see that clearly. I had messed up my coding so bad I could not figure what was happening. Fixed that one, found another coding probl...

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