I have a form which contains a combo box. When the user selects a record from the combo box I want that record to be displayed on the form. But I'm getting a type mismatch error. Here's the code.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[PartN] = " & Str(Nz(Me![Combo34], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
PartN is a text field by the way. What is wrong with the code?