Edit command

[vb4me]

Hello,

I have access XP and I need to use the .edit option in a module. It does not exist though. I have editmode? and update but no edit. If I use tblName.edit anyway and compile it I get the error saying it is not valid and generally in the past I would just make sure the reference was there for it. I believe the reference is the DAO 3.6 and I have this installed.

Any ideas why edit would not be valid or even there?

 

[mikevh]

ADO doesn't have the .edit method and it thinks you're
trying to use ADO even though the code is DAO.
You can either disambiguate all your object declarations
by saying, e.g.,

Dim db as DAO.Database
Dim rs As DAO.Recordset

or go to Tools > References in the VB Editor and
move the DAO 3.6 reference above the Microsoft ActiveX
Data Objects reference. Whichever one is closer to the
top of the list will have precedence.

 

[vb4me]

Your a legend - thanks very much - it is really annoying when it is so simple

 

[lanelouna]

in fact i added like you said previously, but this time for recordset : DAO.recordset and it works
thank you