I have a form with names, addresses and ID Numbers. I created a Combo Box using the wizard to search for the Fullname (Lastname,
Sub Combo21_AfterUpdate()
‘ Find the record that matches the control.
Me.RecordsetClone.FindFirst “[FullName] = ‘” & Me![Combo21] & “‘”
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
It seemed to work until I found a member Smith, John where there were 4 Smith, John ‘s. Of course each has a unique ID Number.
The Combo Box lists ALL 4 Smith, John ‘s but when you click on any of the 4, it ALWAYS finds the FIRST as the code says. I don’t want any navigation boxes to move from record to record.
Anyone have a fix for this?????
Thanks
Alan