T tmarsh tmarsh Local time Today, 10:45 Joined Sep 7, 2004 Messages 89 Jan 5, 2006 #1 I have a form/subform linked to 2 tables, staff and training. The subform lists training done and is sorted by course. How can I change the sort order to a different field? E.g. date? Thanks.
I have a form/subform linked to 2 tables, staff and training. The subform lists training done and is sorted by course. How can I change the sort order to a different field? E.g. date? Thanks.
S Sergeant Someone's gotta do it Local time Today, 05:45 Joined Jan 4, 2003 Messages 638 Jan 5, 2006 #2 In the subform's property sheet, under 'data' tab, set Order By to the field name (eg... TngDate or TngDate Desc).
In the subform's property sheet, under 'data' tab, set Order By to the field name (eg... TngDate or TngDate Desc).
T tmarsh tmarsh Local time Today, 10:45 Joined Sep 7, 2004 Messages 89 Jan 5, 2006 #3 Sergeant said: In the subform's property sheet, under 'data' tab, set Order By to the field name (eg... TngDate or TngDate Desc). Click to expand... That did the trick. Thanks.
Sergeant said: In the subform's property sheet, under 'data' tab, set Order By to the field name (eg... TngDate or TngDate Desc). Click to expand... That did the trick. Thanks.
