Okay, I have been searching this forum for two days for a way to sort by a field on my subform, and so far none of the answers are working for me. I have two tables one is named tblTimeSheet, and the other is tblSubTimeSheet. tblTimeSheet has three fields in it: Client, ServiceOrder(PK), and StatusOC. tblSubTimeSheet has six fields in it: PrimKey(just an autonumber), ServiceOrder, ServiceDate, Stime, Etime and WorkDone. I based the mainform on tblTimeSheet and the subform on a query of tblSubTimeSheet (the query for the subform has ServiceDate in the left most column and it is set to sort ascending). I linked the Master and Child fields to ServiceOrder. When I open the form it is still sorted by the ServiceOrder number. Maybe I'm just not reading your previous answers correctly. Any help would be appreciated.