OrderBy on SubForm doesn't sort records
Posted on 2008-11-13
The AllowFilter property of the subform is set to "Yes". The subform's RecordSource property points to a query that has "CBEQ" as one of the cols. The form's OnOrder property is "CBEQ DESC".
The rows don't display in CBEQ DESC order.
I know I can add the sort to the query, but different cols can be selected by a control on the main form and thus change the displayed sort order. So I need to be able to change the reference in the OnOrder.
The form in its saved state has the OnOrder property set as described above and after opening the form the records aren't displaying in the correct order. I tried leaving off the DESC, but it still displays in the same order.
Any suggestions of how to fix this problem?