RE: Sorting a recordset

From: kiloez (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 08:36:10 -0800

Problem solved. The correct syntax is:

Set ctlADO.Recordset = rs
ctlADO.Recordset.Sort = [Amount] DESC

Oh well...

     
     ----- kiloez wrote: -----
     
     I'm trying to sort a recordset that is getting passed to an ADO data control and getting an error: "Expected end of staement". The code being used is as follows:
     
     Set ctlADO.Recordset = rs
     ctlADO.Recordset.Sort = "Amount" DESC
     
     "Amount" is the field name I'm trying to sort on. Any help in sorting this out would be appreciated.