List Items on a subform in Acsending Order

[Leaner79]

Hi,
I have a form that has several subforms.
I would like records in the subforms to be listed in acsending order. How do i set this

Thanks

 

[PHV]

Either add an ORDER BY clause in the underlaying queries or play with 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