I have created a combo box that shows 2 fields (strLNCo and strFN) of the records I would like to get. The VBA After Update event is listed below
Private Sub Combo29_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[strLNCo] = '" & Me![Combo29] & "'"
Me.Bookmark = rs.Bookmark
End Sub
I have no trouble going to the very record I am wanting.
Although when I have 2 or more records with the same strLNCO field and differenct strFN field it only goes to the first record that matches the strLNCo field I selected.
My question is how do I get it to go Directly to the strLNCo field and strFN field record I am wanting.
Please ask any question or request any more information to help me on this matter.
Thank You
RobotMush(Technical User)
Private Sub Combo29_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[strLNCo] = '" & Me![Combo29] & "'"
Me.Bookmark = rs.Bookmark
End Sub
I have no trouble going to the very record I am wanting.
Although when I have 2 or more records with the same strLNCO field and differenct strFN field it only goes to the first record that matches the strLNCo field I selected.
My question is how do I get it to go Directly to the strLNCo field and strFN field record I am wanting.
Please ask any question or request any more information to help me on this matter.
Thank You
RobotMush(Technical User)