Cant get .Edit to Work

[tfayer]

When I run my module that contains the .Edit command it gives me a compile error and then highlights the .Edit.

With rs
.Edit
!LastName = strLast
!FirstName = strFirst
!MI = strMI
.Update
.MoveNext
End With

 

[PaulBricker]

What version are you using.If you are running A2002, get rid of the .Edit line and try it. I don't have 2002 but I read somewhere that 2002 doesn't use that method. If you are using some other version, try posting the rest of the code.

Paul

 

[cmmrfrds]

If it is an ADO recordset there is no need for the .edit It is only used with DAO recordsets.