That didn't work. I put the code in the after update event as follows:
Code:
Private Sub Combo2_AfterUpdate()
Dim StrFilter As String
StrFilter = "[First Name] ='" & Me.Combo2.Column(1) & "' And [Last Name]='" & Me.Combo2.Column(2) & "'"
End Sub
When I select a name from the drop down, it only selects the first person (alphabetically) for that first name instead of the actual selection, and the form I'm trying to get to doesn't even open. I've actually tried using .column(0) and (1) as well to no avail.