Change Sort/Order By Code

[DeoM]

Hi,
I have a form named "WorkOrder". I have another form where i have an option group (1) choose to sort the WorkOrder form by WorkID and (2) by CustomerName. So i figured i have to write a code in the On Open Event of the WorkOrder form". If Option=1 then sort the WorkOrder Form by WorkID; if Option=2 then sort it by CustomerName.
Please give me idea of the code i should write. Should it be an SQL Select?
Thanks.

 

[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 FAQ222-2244