Nominate a column in form to sort descending

[Pat]

I have a crosstab query as a source of a form and would like to nominate a column to sort on before it displays the form.

How do I do that?

[Pat]

I put the following code into the form's OnOpen Event:
Me.OrderByOn = True
me.OrderBy = "[query name got from record source].[value obtained from Label1.caption] DESC

It saves me having to display the form then choosing the column and choosing UpArrow in the ribbon

[HansV]

Another way would be to set the sort order in the crosstab query.

[Pat]

How would you do that, on the value field? if so, how do you determine which column you are sorting?

[HansV]

Ah, OK. If the columns of the crosstab query are fixed, you could create a new query based on the crosstab query, specify the sort order there, and use the new query as record source. Otherwise, setting the sort order in the On Open event is better, and it is probably easier in any case.

[Pat]

Yes thanks, it is a dynamic query.
I have a OnClick of all the Label headings where I set it up to sort on a selected column.