A small form question...

[TaeShadow]

I have created a form in Access based on a table. There is one field in the
form that contains a numerical value. I would like to create a text box in which
the user can input a value and have the form update itself to the record that
corresponds to the value the user entered.

This is what I have so far: The name of the text box is Text96. The name of
the field is Jamb.

Private Sub Text96_BeforeUpdate(Cancel As Integer)
Dim rst As Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "Jamb = " & Text96.Text
Me.Bookmark = rst.Bookmark
End Sub

However, this gives me a data type mismatch error. Please help.


Thank you.

 

[vbaprogammer]

"There is one field in the form that contains a numerical value."

At rst.FindFirst "Jamb = " & Text96.text you are searching for a text type instead of a numeric value type. Try

"Jamb = " & Text96.value

Dan