In an Access database, I have a form that, after the user performs a search, displays the name of an employee, the parking tag #(s) that have been assigned to them and their phone extension. I'm using a search box (a combo box) on that form where the user can search using the Tag # to get the results mentioned above. A query showing all the employees and their related Parking Tag numbers is the data source used in the combo box. The combo box also has the following code in an After Update event procedure:
Sub Combo3_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[TagInventory#] = '" & Me![Combo3] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub]
This works well when the user searches by the Tag number.
I'm trying to create a similar search box on another form but in this case the user can search by name. The above code doesn't work where an employee has 2 Parking Tags assigned to them. How do I adapt the code or what other procedure can I use so that all the records are displayed when an employee has more than 1 Tag# assigned to them. What can be used in place of FindFirst or FindLast?
As always, thanks in advance for any assistance