adodc controls help urgently

[Dj Still]

i want to copy the "current record" in adodc1 to adodc2.
how can i do that ?

I also want to add the "current record" in adodc2 to a datareport.
how can i do that ?

please help

[ramesh]

Assuming the two controls are accessing different tables that are identical and the column names are known, the procedure would be something like this:

create a new blank record in adodc2

adodc2.Items("column1") = adodc1.Items("column1")
adodc2.Items("column2") = adodc1.Items("column2")
.....

etc.

[Dj Still]

i am having a problem with the ".items" part , it is not working.

the thing is to copy the current record in adodc1 to adodc2.

can i use this " adodc2.recordset.fields = adodc1.recordset.fields"
or is there another way please help me out

[ramesh]

i am having a problem with the ".items" part , it is not working.

the thing is to copy the current record in adodc1 to adodc2.

can i use this " adodc2.recordset.fields = adodc1.recordset.fields"
or is there another way please help me out

I could be wrong...it's a long time since I've done it, so perhaps the .fields("<column1.name>") may be the way to go.

[Dj Still]

how can i use Sql to select the Current record in a database form adodc1 and then add it to adodc2. ?

[Dj Still]

can this work


search_text2 = txtname.Text

SQL = "Select * From tran Where [" & field & "] Like '%" & search_text2 & "%' "
Adodc1.RecordSource = SQL
Adodc1.Refresh
Adodc2.RecordSource = SQL
Adodc2.Refresh