I am sure this is a simple question...
I am trying to use the MS code for a autolookup drop down on a tect box and button. I am using the following code:
Private Sub Command67_Click()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Last_Name] = " & Str(Nz(Me!Text62, 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
The following statement gives a type mismatch error...
rs.FindFirst "[Last_Name] = " & Str(Nz(Me!Text62, 0))
Help? Thanks! *************
M. MARNEY
I am trying to use the MS code for a autolookup drop down on a tect box and button. I am using the following code:
Private Sub Command67_Click()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Last_Name] = " & Str(Nz(Me!Text62, 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
The following statement gives a type mismatch error...
rs.FindFirst "[Last_Name] = " & Str(Nz(Me!Text62, 0))
Help? Thanks! *************
M. MARNEY