ADODB Recordsetclone

[garth]

I may be trying to do the same thing as Raas, but answers
there don't work.

How do I create an adodb recordsetclone?

Garth Thanks you!

 

[Graham R Seach]

Garth,

Raas's problem exists because he was trying to assign a DAO recordset object
to an ADO recordset object. The two don't mix. Try this:
Dim rst As DAO.Recordset
Dim frm As Form

Set frm = Forms!frmavailableLoads
Set rst = frm.RecordsetClone

rst.Close
Set rst = Nothing

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia