Change in Datagrid

[Vincent Br]

hi in this code.

Private Sub Command1_Click()
Adodc1.RecordSource = "SELECT * FROM Table2"
Set DataGrid1.DataSource = Adodc1
End Sub

Private Sub Form_Load()
Adodc1.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Try\Mydb.mdb;"
Adodc1.RecordSource = "SELECT * FROM Table1"
Set DataGrid1.DataSource = Adodc1
End Sub
how come the datagrid doesnt change...as the query is changed load subroutine works properly....it works if i use 2 different adodc controls....


and 1 more question...how come datagrid doesnt accept a adodb.recordset as its datasource?
please guys i need help..thnx a lot

[cmrhema]

hi in this code.

Private Sub Command1_Click()
Adodc1.RecordSource = "SELECT * FROM Table2"
Set DataGrid1.DataSource = Adodc1
End Sub

Private Sub Form_Load()
Adodc1.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Try\Mydb.mdb;"
Adodc1.RecordSource = "SELECT * FROM Table1"
Set DataGrid1.DataSource = Adodc1
End Sub
how come the datagrid doesnt change...as the query is changed load subroutine works properly....it works if i use 2 different adodc controls....


and 1 more question...how come datagrid doesnt accept a adodb.recordset as its datasource?
please guys i need help..thnx a lot

Datagrid will accept a ADODB.RECORDSET
Before opening set the cursor location to aduseclient
Check out the link
http://www.thescripts.com/forum/thread618625.html