>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
To modify the opened recordset, you need to use the Filter/Find/Seek/Sort method of the Recordset. Note that to be able to use these methods, your recordset must be client-sided (CursorLocation = adUseClient).
It is often faster to add the Where clause to SQL query to retreive only needed data and then requery the database for the new data needed!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com