Form.OrderBy

[RayMilhon]

I have a form/subform data entry system where the subform uses the form.orderby to sort the records on the subform descending. When the main form is opened it works perfectly. however, if the user searches for a specific record on the main form and then goes to that record the orderby stops working. If the user simply changes records without using the search the order by is fine. Why would the search remove the order by on the subform?

[ItsMe]

I do not know why a search would affect the OrderBy property. Perhaps it makes more sense to apply ORDER BY to a query and use that as the RecordSource of the Form.
http://www.w3schools.com/sql/sql_orderby.asp