I am using the FindFirst method and for each record found,
I have a list that's contain a id, first name and last name.
on click on the list it take the same id in the edit box for id
I take an action.
It's seem, When i have the same name it take the first name .
How can i solve this problem ?
Private Sub list0_Click()
Dim rst As Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "[Name]='" & list0.Column(0) & "' And [LastName]='" & list0.Column(1) & "'"
If rst.NoMatch Then
MsgBox "There is No Name"
If Not rst.EOF Then
Me.Bookmark = rst.Bookmark