How to change the sort order in sub-form?

[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

 

[Guest]

Creat a query based on your tblFileMovement.
Sort you new new query in whatever way you want
Save it as qryFileMovement.
Open your subform in designed view.
Right click the empty area (normally grey)
On the properties box select Data
Use the Record Source dropdown to select qryFileMovement
Save to form
Open the main form and you will see the subform has been sorted (from the
new query)