Sorting Records in a SubForm

[swicklund]

I have a subform (based off a table) where I would like to sort the records by date. I have tried the "Order by" property for the subform, but nothing changes.

Is there a way that I can get the records sorted, without having to write a query to base my subform off?

Thank you,

 

[PHV]

Take a look at the OrderBy and OrderByOn properties of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886