>>You can sort your in-memory recordset.
>>Populate your recordset and then use rst.sort="Submit, Office"
>
>When using the following code, I recieve the message that the sort oder cannot be applied. What Have I missed? I'm sure its a simple thing that I should see as clearly as the nose on my face. I have changed the Desc field/col to bDesc to avoid keyword confusion. ...

I really think that the problem is with adBSTR. Try to use adVarChar (and specify a length also).

If this is of no help, add these lines before adding fields:

RS.CursorLocation = adUseClient
RS.LockType = adLockPessimistic