G
Guest
I have a combo box that should goto a record on the form based on the
selected value in the combo box.
Right now all you get is type mismatch error.
Here is the code in the combo box.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[UserID] = " & Str(Nz(Me![Combo101], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Refresh
TIA,
Tim J
selected value in the combo box.
Right now all you get is type mismatch error.
Here is the code in the combo box.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[UserID] = " & Str(Nz(Me![Combo101], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Refresh
TIA,
Tim J