I think you need to re-set the datasource whenever you change your query.
this works fine with me.
HTH
ADSC
>Hi
> When i set a datasource to my datagrid in VB6.0. it works fine in the first try .. but when i execute another query with my ADO data control... the resulting data in my grid is not refreshed.
>
>Can someone help me out with this??
>Regards
>Pranav.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>