DAO.recordset and reference

[joe_walker]

I'm having problems with edit method and referencing to DAO. I work in Access 2002, and have turned on MS DAO 3.6 Object library. I can find it in object browser, but it doesnt show up in form.

Thanks

 

[Tim K.]

It seems to me that you also have set ADO in the References. If this this the case, you have to add DAO as a prefix to all DAO objects. Something like this.

Dim dbs As DAO.Database
Dim rst As DAO.Recordset
...

 

[joe_walker]

yes, how dumb of me.

Thanks a lot!