I am trying to look up a record on a form using the following code:
Dim rst As ADODB.Recordset
Dim strCriteria As String
strCriteria = "[IN_NUMBER] Like '" & [Forms]![frmInmateMaster]![txtFindInmateNumber] & "'"
Set rst = Me.RecordsetClone
rst.FindNext strCriteria
If rst.NoMatch Then
MsgBox "No entry found"
Else
Me.Bookmark = rst.Bookmark
End If
The problem is whenever I test the code to see if it works, I end up getting a "Method or data member not found" message. What access method should I use in this situation?
Dim rst As ADODB.Recordset
Dim strCriteria As String
strCriteria = "[IN_NUMBER] Like '" & [Forms]![frmInmateMaster]![txtFindInmateNumber] & "'"
Set rst = Me.RecordsetClone
rst.FindNext strCriteria
If rst.NoMatch Then
MsgBox "No entry found"
Else
Me.Bookmark = rst.Bookmark
End If
The problem is whenever I test the code to see if it works, I end up getting a "Method or data member not found" message. What access method should I use in this situation?