How to use ADO for editing with if

[Guest]

Hi
I wnat to convert my DAO recordset to ADO but I m not getting how I will
manage this with ADO now I m using DAO recordset which is as follows:

Set rst = db.OpenRecordset("SELECT * from tEmployeeData WHERE CardNO=" &
CardNo & "")
If rst.RecordCount = 1 Then
rst.Edit
Else
rst.AddNew
rst!CardNo = CardNo
rst!EmpName= EmpName
In short if record is present it will appear for editing else i will add new
record.
please let me know.
Thanks

 

[Alex Dybenko]

Hi,
try:

If rst.eof Then
rst.AddNew
end if

rst!CardNo = CardNo
rst!EmpName= EmpName
rst.update

an example to open recordset - you can find in access help

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[RD]

Why would you want to convert to ADO?

 

[Guest]

Thank you very much
just one command and solve my all problems.
Wahab