You can sort your in-memory recordset.

Populate your recordset and then use rst.sort="Submit, Office"

>I have a requirement to allow sorting in the listbox. Not on the first element but on one OR two of the elements in the list. My desired end result is to be able to 'Order by Submit, Office'
>There is the ability for them to modify the subission status so the data in the list no longer matched the origional data drawn from AND they have the option to renig their requested changes. In a nutshell I need to be able to get an Order by item, item2 type result from list items that are not in a table. :(
>
>>What do you need exactly? You can use the Filter method or the Find method but you can't SELECT on a recordset.
>>
>>>How would I query against this on the fly recordset? Its built from a listbox. the listbox items are created from other individual elements.