combo box search not showing few records in access2010
I have a combo box to search records in a form. (below the code).
But it will not return some records. I can see that record in the combo box. When I select that record it will show "Not found"
But if I open the table I can see that record.
Your help appreciated to sort out this
Dim rs As DAO.Recordset
If Not IsNull(Me.Combo144) Then
''Save before move.
If Me.Dirty Then
Me.Dirty = False
Set rs = Me.RecordsetClone
rs.FindFirst "[Sno] = " & Me.Combo144
If rs.NoMatch Then
MsgBox "Not found"
Me.Bookmark = rs.Bookmark
Set rs = Nothing