New to ADO

[AndyShuter]

Can someone please help me with what I am sure is dead simple!

I know how to create a new record using dao

' Add Dummy Acceptance Criteria

Dim rsAcceptanceCriteria As Recordset
Set rsAcceptanceCriteria = New Recordset

rsAcceptanceCriteria.Open "tblAcceptanceCriteria", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

rsAcceptanceCriteria.AddNew
rsAcceptanceCriteria("DealCode") = Me.DealCode
rsAcceptanceCriteria.Update

However, what I would like to do if poss is find an existing record (by Deal Code) and than update that particular one.

many Thanks

Andy

 

[AndyShuter]

Thanks,

Did that - I think I've almost cracked it but have just one syntax error


rsAcceptanceCriteria.Find"DealCode" = Me.DealCode

isnt working

but If I change this to

rsAcceptanceCriteria.Find"DealCode" = 385

it works

Am I doing something wrong?