I have a form (called TabularPrice) with ADODC control and MSHFLEXGRID
control on it.  MSHFLEXGRID is linked to ADODC control.
But  when I try to change the the recordsource of ADODC from following code,
it gives me ADODC Unknown Error on ADODC Refresh statement. 

        TabularPrice.Show
        tstr = "Select Projectno, Itemno,Description,Units, Unitprice,
purchasedondate from Table1 ;"
        TabularPrice!Adodc1.CommandType = adCmdText
        TabularPrice!Adodc1.RecordSource = tstr
*	  TabularPrice!Adodc1.Refresh
        Set TabularPrice!MSHFlexGrid1.DataSource = TabularPrice!Adodc1
        TabularPrice!MSHFlexGrid1.Refresh

Pl. help



Anita