Hi Jim. Maybe if you could post a screenshot, it would make it clearer what you mean. In the meantime, maybe you could also take a look at the Rearrange Sort Order Demo from my website, in case it is similar to what you're trying to do.
Something that you can use to help explain what you want.
If you are not going to want to change the sort order all the time, why not get the sort correct for the source of your form?
Good point, I am wanting to add this mostly as an exercise. I may not really need it but want to learn how.
Ah, thanks for posting an image. It definitely does look like any of the approaches I showed in my demo might apply with your setup. Have you had a chance to take a look at it?
Hi Jim. No better time to start learning than now. Take a look at the code behind the demo and post questions on anything you don't understand. Does your table include a sort order field?
Hi Jim. Just to clarify, what you have downloaded from the website should have been a ".zip" file. If you simply double-clicked on it and then double-clicked on the ".accdb" file in it, then you might get that "ding" from Windows. Is this what happened?
I downloaded then extracted to a folder then opened in Access. Had to close the popup window to be able to click the trust. then I can click one of the three options. Once it opens the form I can right click to open in Design View. other than that I cannot do anything else.
