SetOrderBy ASC works but not DESC

[mindea]

I have an Access form based on a single-table query (with no sorting) displaying Continuous Forms. I can manually click in any column and sort Ascending or Descending using the selectors in the Sort & Filter tool bar, or by right-clicking and selecting from the menu Sort Smallest to Largest etc.

I added a button above the Managers column with this code: DoCmd.SetOrderBy "Managers, ASC" It works great.

However, if I change the code to sort DESCENDING --DoCmd.SetOrderBy "Managers, DESC" -- it still sorts Ascending

I've tried it against other columns with the same outcome -- can't get any column to sort Descending.

Am I missing something?



[Windows 10, Access/Office 365]

[davegri]

I don't think you need the comma before asc or desc.

[Welshgasman]

Access probably thinks that DESC is a field.? as the default is ASC anyway?

https://docs.microsoft.com/en-us/off...cmd.setorderby

[Gicu]

Could you please try to replace the code in your button click event with:

Me.OrderBy = "Managers Desc"
Me.OrderByOn = True

Cheers,
Vlad

[mindea]

Gadzooks! I was including a comma where none was needed.
Many thanks for the help.