New to DAO

[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

 

[Mile-O]

The code you are using is ADO; not DAO.