yes it is a SQL command but if I use

adodc1.Recordset.Open "Select * From Table ORDER BY [AdjusterLastName]

It works fine till I filter the recordset then it will not ORDER BY

I have to filter the recordset since the user selects a Client and based on that client only those Adjusters associated with that client appear in the DataCombo Adjusters list hence the original problem where the recordset is filtered by a Client DataCombo.

I dunno why it doesn't maintain the original ORDER BY when it is later filtered