I'm using the following code to look a user up by a pin code which works fine. But how do i alert the user if a match is not found. I tried to create a blank record as the first record in the table and match by a blank textbox but couldn't get it to work
Code:
Private Sub cmdSearch_Click()
Dim strCriteria As String
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
strCriteria = "[ConCode] = '" & Me![ConCodeLookup] & "'"
rst.FindFirst strCriteria
Me.Bookmark = rst.Bookmark
End Sub