G
Guest
Hello All,
I have a Combo box that looks up values in the Last Name field. It works
fine but it only BookMarks the first occurance of any matching criterior. My
Combo box has two columns "Last Name", "First Name". What I would like to do
is modify the code to force it to bookmark criterior based on both fields if
that's possible.
Here's the code for the Combo box:
Option Compare Database
Option Explicit
Const adhcQuote = """"
Private Sub cboFindLast_AfterUpdate()
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "[Last Name] = " & _
adhHandleQuotes(Me!cboFindLast, adhcQuote)
If rst.NoMatch Then
MsgBox "No match was found."
Else
Me.Bookmark = rst.Bookmark
End If
Set rst = Nothing
End Sub
I have a Combo box that looks up values in the Last Name field. It works
fine but it only BookMarks the first occurance of any matching criterior. My
Combo box has two columns "Last Name", "First Name". What I would like to do
is modify the code to force it to bookmark criterior based on both fields if
that's possible.
Here's the code for the Combo box:
Option Compare Database
Option Explicit
Const adhcQuote = """"
Private Sub cboFindLast_AfterUpdate()
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "[Last Name] = " & _
adhHandleQuotes(Me!cboFindLast, adhcQuote)
If rst.NoMatch Then
MsgBox "No match was found."
Else
Me.Bookmark = rst.Bookmark
End If
Set rst = Nothing
End Sub