Hello there,
I have created a combo box within a form in order to search for a specific manufacturer claim no.
However, the 'job form' can have records that have duplicate manufacturer claim nos within a specific Dealer code.
I have the code to search for the manufacturer claim no
Private Sub Combo196_AfterUpdate()
Dim MyRecSet As Object
Set MyRecSet = Me.Recordset.Clone
MyRecSet.FindFirst "[MANUFACTURER Claim No] = """ & Me.Combo196 & """"
Me.Bookmark = MyRecSet.Bookmark
End Sub
But I need to add a secondary search that will pick up the [dealer code] to then complete the search.
Please Help.
Thanks
I have created a combo box within a form in order to search for a specific manufacturer claim no.
However, the 'job form' can have records that have duplicate manufacturer claim nos within a specific Dealer code.
I have the code to search for the manufacturer claim no
Private Sub Combo196_AfterUpdate()
Dim MyRecSet As Object
Set MyRecSet = Me.Recordset.Clone
MyRecSet.FindFirst "[MANUFACTURER Claim No] = """ & Me.Combo196 & """"
Me.Bookmark = MyRecSet.Bookmark
End Sub
But I need to add a secondary search that will pick up the [dealer code] to then complete the search.
Please Help.
Thanks