restore sort order after filter cancel

[Bart]

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 via AccessMonster.com]

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