Cobo Box lookup record on a form

[SAC]

After I lookup a record using a combo box, I can't lookup another one. I
acts like it is "stuck." Here's the code I have:

Private Sub Combo114_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[wotrhKey] = " & str(Nz(Me![Combo114], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo114 = ""
End Sub

Any ideas?

Thanks.

 

[Jeanette Cunningham]

Hi SAC,
make sure combo114 is an unbound combo. It should not have anything in its
Control Source.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia