Wondering if you can have multiple selection criteria in a .find method
The .find is erroring out.
Oops, okay .find doesn't allow multipe search options. Back to the drawing board with .filter or a secondary SQL statement....
Code:
sArrayNames = Split(cboReviewer.Text, ", ")
sName = sArrayNames(0)
fName = sArrayNames(1)
'
With pobjADOtable
.MoveFirst
.Find ("FirstName='" & fName & "' and LastName='" & sName & "'")
The .find is erroring out.
Oops, okay .find doesn't allow multipe search options. Back to the drawing board with .filter or a secondary SQL statement....
Last edited: