Can I assign form's recordset to ADO's rst ?

  • Thread starter Thread starter S.L.
  • Start date Start date
S

S.L.

I found that if I use ADO I can not write like the following, it generates
Type Mismatch error. :

Dim rst as New ADODB.Recordset

Set rst = Form!MyForm.RecordsetClone

If I change ADODB.Recordset to DAO.Recordset, Everything is OK.

1) How to assign form's recordset to ADO's rst ?
2) Except syntax,method,property I ever used on ADO, Do I also have to
change the way I programming with form's recordset ? ex., Bookmark...

TIA
 
IIRC, the Form's Recordset in an MDB is defaulted to DAO Recordset so you
can't assign it to an ADO Recordset.

However, you can create an ADO Recordset using the same Query/Table as the
Form's RecordSource.
 
Thank you for your help. It make me headache for whole day. Execuse me, May
I ask you a little bit more ? Is this information in Access help file ?
 
Back
Top