I can't scroll thru records using my combo drop-down.

[Denise Walker via AccessMonster.com]

I can't scroll thru records using my combo drop-down. When I click my drop
down with the code below, the record changes, but not the recordid. What
happens is that the new record overlays the current recordid. What I would
like is for the User to click on the combo box and pick a name. then from
that name, the correct record populates the fields. What is wrong with my
code?

Dim rs As Object

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

 

[Allen Browne]

See reply to same question 2 hours later.
BTW, make sure the combo is unbound.