ado .find method, multi select possible?

Salient

Registered User.
Local time
Today, 23:16
Joined
Aug 14, 2007
Messages
63
Wondering if you can have multiple selection criteria in a .find method

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:

Users who are viewing this thread

Back
Top Bottom