Access : Select table references.

http://www.classanytime.com/mis333k/sjdaoadorecordsets.html

Find First Record (DAO)  

rs.MoveFirst
rs.FindFirst "pkPeopleID=2"

If rs.NoMatch = True Then
    Debug.Print "Not found"
Else
    Debug.Print "Found"; rs!pkPeopleID; rs!FirstName; rs!LastName
 End If

Find First Record (ADO)  

rs.MoveFirst

rs.Find "pkPeopleID=2", , adSearchForward

If rs.BOF Or rs.EOF Then
    Debug.Print "Not found"
Else
    Debug.Print "Found"; rs!pkPeopleID; rs!FirstName; rs!LastName
 End If