Custom Recordset Sorting

• • Reply

  19 years ago

  by gigsvoo

  gigsv00

  , United States

  Joined 19 years ago

  Hi there,
  

  
  How can I sort a custom recordset? I uses the following statement:
  

  
  Rs1.Sort = "Field1 ASC"
  

  
  and it return this error:
  

  
  Order cannot be opened

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  Are you using ADO or DAO. I would strongly recommend using ADO, and then you can just use a SQL statement...

  Report abuse