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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search combo box 2
OnLoad event criteria 7
RunTime Error 3070 11
Searching 3
Error 2147352567 2
Textbox Filter 4
Combo Box Error 3077 - Access 2003 1
VBA for NotInList return to old record or BeforeUpdate value 2

Top