Sorting recordset with code

I'm access a recordset with a data control. Is there a way to sort one the field of the recordset with code.

Give the following statement in the recordsource property of the datacontrol.
"select * from itmemaster order by Code"
Change the tbale and field name as required.

Rgds