Från: "Jeanette Cunningham" <n...@discussions.microsoft.com>
Ämne: Re: Cobo Box lookup record on a form
Datum: den 3 november 2009 21:57
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
"SAC" <s
...@somewhere.com> wrote in message
...
> 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.
|
