this code below using a DAO connection library

Data1.Refresh

If Data1.Recordset.RecordCount > 0 Then

Data1.Recordset.Edit

Data1.Recordset("RYC") = rsData!COMM

Data1.Recordset.Update
End If

i want this to convert to ADO conncection library, please any one advice me how to do it. i had try this query "con.execute Update table set field1 =field2 where field3>1" it works but i want to update only a single row not all the records contained in field3.

please help tnx

mnar0930