>>How can I Sort and change the Sort field in an ADO RecordSet?
>
>Do you mean once the recordset is opened? In this case use this syntax:
>

rst.Sort = "YouFieldName"

Thanks Eric.
Yes, the RecordSet is already Opened with multiple fields returned.

Need another advise. If I changed the Sort order on another field name
in the RecordSet, I don't seems to be able to use locate a record by

rst.Find "FName LIKE '" & strName & "'"

Anything wrong with my code? Pls advise, thanks.