Hi I have a dropdown box with a SQL Query to list name, address etc. That will then populate the a form with that persons info.

My code has:

Private Sub Combo1_AfterUpdate()
    Me.RecordsetClone.FindNext "[MemberId] = " & Me![Combo1]
    Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

But, This only allows me to go forward in the records. If I need to choose a record before this it doesn't go there.

Anyone know How I should do this?

THanks!

Never mind found the answer:

  ' Find the record that matches the control.
    Dim rs As Object

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