>>Hi,
>>Does Recordset.Find support multiple find, like if I want to find data in 2 or 3 fields in the same command : ex
>>RecordSet.Find buildingname=2 and unittype=10 and unitno=30 ??
>>
>
>I forgat to say this is using ADO.
You can't find multi-criteria.
You have to alternative to that:
-Use the Where clause of your Select query to replace some of your criteria.
-Use the ADO Filter property (which can accept multiple criteria). Be advise that the Filter can be very slow on a large recordset.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com