Search, retrieve record

J

Jean

I have the following event stmt set up to do search and
retrieve that records info:

Private Sub Combo177_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo177])
Me.Bookmark = rs.Bookmark

I get the following error:

Runtime error 3464. Data type mismatch in criteria
expression.

ID is a text field. What am I doing wrong?
 
Top