Access Web App - Sort combo box Descending

[dz227]

I have an Access Web App and I have a blank page with a combo box that references a list of dates in a table. These are month end dates. Access seems to automatically sort these in ascending order. I have tried referencing a query that sorts the dates Descending, but the combo box still has the list ascending.



Is it possible to override this?

Here is the query





Here is the combo box setup


And live result

[Homegrownandy]

Is the combo box using the query or the table as a reference? (its source)

[dz227]

"Row Source" is referencing the sorted query, and Bound Field and Display Field are referencing the column of the Descending Dates in the query. See my screenshot examples.

[Homegrownandy]

I see. I've never seen the properties displayed in such a way. I assumed that was something you made..? Or is that normal in webb app?

[dz227]

This is what Access Web Apps 2016 looks like. These are screenshots from Access 2016. (I don't have the skill to custom make something like this.)

[CJ_London]

I presume you have saved your query with the descending sort before opening the form? If it is still open, the form will be referencing the original unsorted version.

I don't use web apps, but it may be you have to delete the rowsource, save, then reselect it to update the underlying code

[Micron]

cross posted here
https://www.mrexcel.com/forum/micros...escending.html
dz227 (or dlz227 as the case may be) please review this page
http://www.excelguru.ca/content.php?184