Using an ADO Recordset, I opened a query in the following manner:

SELECT Units.UnitID, Units.StreetName & ' ' & Units.StreetNumber as Address FROM Units

Then, when I tried to set the Sort Property to Address:

rstUnits.Sort = "Address"

I got a runtime error "Order cannot be opened", which doesn't appear anywhere on the internet or MSDN.

I _did_ remember to set the CursorLocation property to adUseClient, and it _does_ work if I set the Sort property to "UnitID".

I didn't see documentation anywhere that states that only real databse fields can appear in the Sort property.

Any insight on the matter will be appreciated.
Thanks.

Israel