Where is Sorting Order stored?

[Guest]

Hi,

I've a form in MS_Access, based on a query say
Select a, b, c
from table
order by a

Running the form shows the rows ordered by a, but I can change the sort
order by clicking column heading of b and clicking the sort button. When I
run the form again, sort order is by b.

Where is that information stored??

Thnks for hlp

Henk

 

[Allen Browne]

See the OrderBy property of the form.

Note that this property is only operational if the form's OrderByOn property
is true.

 

[Guest]

Thanks, Allen,

I see the OrderBy property changing. But I don't see the OrderByOn property
in the properties window. Is it only to set in VBA?

 

[Allen Browne]

Yes, that's right: set through VBA. More in the help file.