I have my code which finds a record in a datagrid, using an adodc. What I want is my other adodc to point to the record that the first one is.
So e.g. the adodc2.recordset will point to the same ID thats been found.
Sorry if I have explained this badly.
Code:
Private Sub Command3_Click()
surfynd = "Surname=" + Chr(39) + RichText1.Text + Chr(39)
Adodc1.Recordset.Find surfynd
Text1.Text = Adodc1.Recordset!Surname
So e.g. the adodc2.recordset will point to the same ID thats been found.
Sorry if I have explained this badly.