>Hello everyone,
>If I have an adodc connection with SQL attached to it for one form and I have a separate form that I would like to be use the same connection so that any record that is displayed on the first form will be the same record on the second form but show different fields on the second form for that record. I'm using a .udl data link file as the connection with a SQL statement just being "Select * from myTable"
>Thanks for your help in advance!
>Max

Try this:
set form2.adodc1.recordset = form1.adodc1.recordset