I don't want to use the Filter, it's very big Recordset, even I don't want to use Find.

Can I change my SQL statment in the record set without reopen it Iam using this code
with rstUnits
.Active connection = myConn
etc....
.Source = "SELECT * FROM units ORDER BY unitname_a"
.open
End With

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