Filter by Form Sorting

[Guest]

I have a relatively simple relational database. One of my forms is based on a
query with a 3 parameter sort: Status / Priority / Customer.

When I open the form, the records are sorted properly according to the sort
order on the query. Only the records selected by the query are showing.

When I go to filter the form, to get a subset of the form, e.g. filter by
Responsible Party, I would like the form to sort this way:

Reposponsible Party / Status / Priority / Customer.

However, when I do the Filter by Form, the sort gets all screwed up, so much
so that I can't even determine that it is sorted in ANY order - it appears
random.

Virtually all my forms are doing the same thing - when I filter the form, it
loses its sort.

Help!

thanks,
carl

 

[John Vinson]

I have a relatively simple relational database. One of my forms is based on a
query with a 3 parameter sort: Status / Priority / Customer.

When I open the form, the records are sorted properly according to the sort
order on the query. Only the records selected by the query are showing.

When I go to filter the form, to get a subset of the form, e.g. filter by
Responsible Party, I would like the form to sort this way:

Reposponsible Party / Status / Priority / Customer.

However, when I do the Filter by Form, the sort gets all screwed up, so much
so that I can't even determine that it is sorted in ANY order - it appears
random.

The records will be sorted in whatever order the query optimizer finds
convenient, unless you tell Access otherwise.

Try setting the Form's OrderBy property to the desired sort order, and
its OrderByOn to True.

John W. Vinson[MVP]

 

[Guest]

I've set the Order by property to the correct sort, and it's still wrong.

I cannot find the Orderbyon property to set it to true.

Any other suggestions?

thanks,
carl

 

[Rick Brandt]

I've set the Order by property to the correct sort, and it's still wrong.

I cannot find the Orderbyon property to set it to true.

OrderByOn is not in the property sheet. It is set to True either in code...

Me.OrderByOn = True

....or by using one of the GUI devices to "Apply Filter/Sort".