Filter by Selection - underlying sort ignored

[WantToKnowMore]

On my form I have several fields that I allow the user to "Filter by Selection"; they can filter on up to 5 fields and this works. The records are filter down to the exact ones they want to see.

However, the underyling query has a sort on these fields and when filter is off, the sort works fine; if any one or more fields have been selected by the user with "Filter by Selection", the sort sequence is disregarded. I am assuming that it goes back to physical order.

Any ideas what I can do to perserve the sort in the query?
Thanks!

 

[PHV]

After setting Me.FilterOn to True you may try to play with Me.OrderBy and Me.OrderByOn

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886