>Thank you, Eric.
>It works first time for me. Then I am rebuildig recordset and
>Set adodc.recordset = NewRecordset
>adodc.Refresh
>
>But it doesn't refresh Adodc. What do I do wrong or what else I need to do?
It is supposed to work. Is your ADODC bound to a control ? Maybe you need to refresh that control (ie: datagrid1.refresh). Try setting the ADODC recordset to nothing (Set Adodc1.recordset = Nothing).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com