I have a form in datasheet view, whose Recordsource contains both an Order Date field and a CustomerFK field. The Orderdate field is sorted ASC.
Simply right clicking the CustomerFK field and Filtering by say "3", naturally yields BOTH all orders from CustomerFK=3 AND preserves the Orderdate field sort ASC. Of course, since nobody likes to Filter by CustomerFK, but rather, the customers actual name, I use a combobox populated with the FK in the bound field and the Name in the second column. No problem.
The kicker is this: Filter by the Customer's actual name and you lose the sort on Orderdate ASC. Not so if you filter by the FK number directly. Why so?
I figure it's a common issue. I've made a super-simple db to illustrate with 2 forms, one working, one not. What is the accepted way of circumventing this?
Filtering removes sorting.zip