Asc/Desc/reset sort button code

[mightyteegar]

I have a form whose query pulls the 20 most recently modified records from a table. The form design has column headers at the top and a small set of fields in the form body. By default (on form open) I want to show the form's rows as returned by the query, i.e. sorted by modification date starting with the most recent. All of this is working.



Now I want to be able to click on the "CustomerName" header at the top and perform a toggle sort *with that exact recordset* by CustomerName, i.e. ascending-descending-reset to default (by mod date), all with the last 20 modified rows. Anyone who uses the Spotify media app will know what I'm describing -- they offer the exact same sorting mechanism for song search results.

I have no idea how to go about this as my programming skills are improving but still very basic. Can someone help?

[June7]

One way may be using code to set the OrderBy property of form. I never have used this, I have set Filter and FilterOn properties.

Might require the RecordSource to not have SORT BY clause.

[ssanfu]

Something like this?? It is a just a single column sort.... multiple column sorts are a lot more complicated.