Sorting recordset with code

[zoom14151]

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

[Praba S]

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