Cobo Box lookup record on a form

  • Thread starter Thread starter SAC
  • Start date Start date
S

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.
 
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
 
Back
Top