I have created a ADODC in a form(frmABC). I have specified the connection
string and record source at design time.

When I'm trying to change it run time, it accepts the command still gives
the old results.

Also, When I tried to take the connection string and record source, it is
giving an error at run time

frmABC.Adodc1.ConnectionString = ""
frmABC.Adodc1.ConnectionString = gConnection

frmABC.Adodc1.RecordSource = " "
frmDBrowse.Adodc1.RecordSource = str_select_statement

With frmDBrowse.Adodc1.Recordset
End With

Is there any way to programatically change the parameters in an ADODC?