>>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.