Rowset error message

[JamesEdwards]

I have a record set which retrieves multiple records. If I use recordset.find,criteria it gives me the error message; 'Row set does not support scrolling backwards'

Any ideas on getting round this would be appreciated.

Thanks ,
James.

 

[NKSBenny]

You need to open the recordset with a static, keyset or dynamic cursor type. This means it must be opened with a command object, and not just with a Connection.Execute().