ADODB Recordsetclone

  • Thread starter Thread starter garth
  • Start date Start date
G

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!
 
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
 
Back
Top