adodc control gives "subscript out of range" error

[hinchdog]

i have an adodc control on my startup form. in the forms load event i use this code...

sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Classes.mdb;Mode=ReadWrite;Persist Security Info=False;Jet OLEDBatabase Password=TEST"

With Adodc_Teacher
.ConnectionString = sConnect
.RecordSource = "Select * From Teacher WHERE ID=1"
.Refresh
End With

i have the adodc to use a connection string with a commantype "adCmdText". anyone see the problem here??

 

[Paddyo]

Im not sure

It might be because you have the code in the formload event.

Why not create a command button on the form which runs this code - just to see it the code is ok.

Remove the code from the load event.

Good luck