like comparison

J

Jenny

Is their a method to replicate the like comparison used in
a table by selecting the match any part of field option?
In findfirst . Replacing the equals with like?

rcdAmendPC.FindFirst "company Like '" & Sname & "'"
 
D

Douglas J. Steele

rcdAmendPC.FindFirst "company Like '*" & Sname & "*'"

In some cases (such as when you're using ADO), you'll need to use % as the
wildcard instead of *
 
J

Jenny

Thanks
Jenny
-----Original Message-----
rcdAmendPC.FindFirst "company Like '*" & Sname & "*'"

In some cases (such as when you're using ADO), you'll need to use % as the
wildcard instead of *

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)





.
Click to expand...
 
Top