Whichever method you use to access your database, you have basically two ways to sort the data.

One way is while retrieving records into the recordset you can frame the query with an 'Order By' clause to have the records sorted before they are sent to the recordset.

Another way is if you already have a recordset, use its .Sort method to sort the records in the recordset.

The first method is useful if you don't need to re-sort your data again and again. But if you are allowing the user to select and later change the order of sorting I believe you are better off with the second method.