Me.RecordsetClone

[Mark A. Sam]

I am having a problem set a variable to RecordsetClone like,

Set rs = Me.RecordsetClone

It results in a ODBC Call failed when executed. Is there a way to solve
this without having to address the forms underlying recordset such as a
table or query? I am using linked SQL Server tables.

God Bless,

Mark A. Sam

 

[Douglas J. Steele]

I may be off base here, but how did you declare the recordset (and what
version of Access are you using)?

If you've got references set to both ADO and DAO, and you don't explicitly
Dim rs As DAO.Recordset, I think you're going to have problems.

 

[Mark A. Sam]

Doug,

Dim rs as RecordSet. I'll try the DAO.Recordset, but I didn't think it was
necessary if I was using the DAO library.

It is Access2002. Referencing the Recordsetclone is not problem doing
finds, but it doesn't like the update method.

Also, I am having a problem with it recognizing a bookmark, but that is
another post.

God Bless,

Mark