Hello,
I have a question about filtering using the standard toolbar functions. How
can I maintain or restore my orderBy settings when a user chooses Apply
Filter, Remove Filter (or Apply Filter/Sort, Remove Filter/Sort)?
thanks.
Paul
heifler - 09 Nov 2007 21:03 GMT
Bart,
orderBy is a form property that can be set in VBA code by stating me.orderBy
= ["Name of sort field"]
You could put this on the click event of a button and even add the filter =""
to remove current filter.
Or you could set the forms datasource (a sorted query) to a set of records
that the query produces.
Please see signature if this is not clear and you need it done for you.
Bob
>Hello,
>
[quoted text clipped - 5 lines]
>
>Paul

Signature
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com