I wonder if part of the issue is that you're not moving first in the recordset (which I would declare as such and not use Object) but that's just a guess because I would be using an autonumber pk field as the bound column - I use one in every table, except perhaps those that I test with to help others out with some issue. Also, by not using a NoMatch test, your bookmark will be arbitrarily set if a match isn't found. I realize you should have a match based on your data, and I can't explain why it doesn't seem to find it. Also, I have read that if you used a wizard to make this combobox, it uses some combination of .FindFirst and .EOF that is invalid, which was a bug that may not have been fixed.
BTW, you shouldn't need a recordset object anyway. You should be able to do this with the clone:
Code:
With Me.RecordsetClone
.FindFirst "fieldNameHere = '" & Me.comboTextValueHere & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End With
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.