I am using a combo box to find a record on a sheet. The problem is this...the record I'm trying to find is a student name. Since there are siblings, there are multiple people with the same last name. I thought that if I found the first name and them hit enter again in the combo box it would search for the next record with that last name, but it's not working. Instead, it finds the first record with the last name of "SMITH", but does not find the other three siblings.
I have hunted and hunted, but I can't find a solution for this. Here's what I tried last, (again, found some hints online) but it doesn't work.
Private Sub Combo56_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindNext "[Student_Last] = '" & Me![Combo56] & "'"
If Not rs.NoMatch Then Me.Bookmark = rs.Bookmark
Okay, I have one more thought on this. I think the issue is that the combo box may be searching for another record with the same FamilyID, rather than the same last name. Is that possibly the problem??