H
hkgary33 via AccessMonster.com
Dear all,
In a main form for user to input and view records, I’ve added a sub-form
which linked with a table called tblFileMovement to show two fields
(StaffName, Date), so that the user can have a clear view on the file
movement of a particular file. My problem is that I can’t successfully sort
the data in the subform by my own. In the “Properties†box, in the “All†tab,
and in the “Order By†box, I’ve already typed “[tblFileMovement].[Date] DESCâ€
in it, but it still can’t show the records in such order, and automatically
show the result in the ascending order of the StaffName by default.
Can anybody help to teach me how to sort the data in the sub-form according
to my own preference but not the default?
Thanks a lot!!!
Gary
In a main form for user to input and view records, I’ve added a sub-form
which linked with a table called tblFileMovement to show two fields
(StaffName, Date), so that the user can have a clear view on the file
movement of a particular file. My problem is that I can’t successfully sort
the data in the subform by my own. In the “Properties†box, in the “All†tab,
and in the “Order By†box, I’ve already typed “[tblFileMovement].[Date] DESCâ€
in it, but it still can’t show the records in such order, and automatically
show the result in the ascending order of the StaffName by default.
Can anybody help to teach me how to sort the data in the sub-form according
to my own preference but not the default?
Thanks a lot!!!
Gary