Same ADO control on 2 forms

[rringsred]

Hello,

I was just wondering if it is possible to access ADO control from one form to a different form. My form became to cluttered and I even added tabs so I simply made a second form. However i cannot access the the control from the original form and it is an updating headache. Is it possible to set the properties to show the control from a different form. Thanks a lot

Ronny

[Lori]

If you want to access controls that are on a different form, you have to preceed it with the form name:

For Example:
To access the ADO data control on Form2 from Form1 you would use the following line in Form1:
Form2.ADODBControl.Recordset.Open [tablename]

[david1]

You may also open the other form and pass a recordset to the other form in one of the methods.
Form1 call form2
Method in form2
....search(rs as recordset)
end sub
Then you maay do
dim f as form2
set f = new form2
f.search recordset

Also you may use a global connection by declaring it as a global, open it and then use it in several forms.
opening different recordsets.

David