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

--
Message posted via http://www.accessmonster.com

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Denise Walker via AccessMonster.com" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>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