Where is Sorting Order stored?

H

hstijnen

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
 
A

Allen Browne

See the OrderBy property of the form.

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

hstijnen

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?
 
Top