like comparison

[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 & "'"

 

[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 *

 

[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)





.