For some reason I can't access the FindFirst property of the recordset:

Private Sub cbWeek_AfterUpdate()

    Dim var As Variant

    var = DLookup("[id]", "Activity_Log", "[StudyID] = " & Me.cbStudyID.Value & " AND [Week] = " & Me.cbWeek.Value)

   Dim rs As ADODB.Recordset

   Set rs = Me.Recordset.Clone

   ' ERROR
   rs.FindFirst "[id] = " & var

End Sub

Ok, I've added the DAO 3.6 library and tried the following code again:


Private Sub cbWeek_AfterUpdate()

    Dim var As Variant

    var = DLookup("[id]", "Activity_Log", "[StudyID] = " & Me.cbStudyID.Value & " AND [Week] = " & Me.cbWeek.Value)

    Dim rs As DAO.Recordset

    Set rs = Me.RecordsetClone

    rs.FindFirst "[id] = " + var


End Sub



... but now I keep getting a type mismatch error on the line "Set rs = Me.RecordsetClone"

Welcome to P2P!

A few ideas to look at:
1)What is the datatype of cbStudyID.value? (string or numeric?)
2) What is datatype of cbWeek.value? (string or numeric?)
3) If your variable var is a string, what happens when you try
rs.findfirst "[id] = '" & var & "'" '?