I have a form, frmMember having 2 subforms, frmDonations and 
frmDonationsDetails.

frmMember 1-m with frmDonations
frmDonations 1 -m with frmDonationsDetails

I am having problems accessing controls on the third form from the main 
form, frmDonationsDetails . I get a error with the Active X or OLE server 
saying there is problem communicating.  It suggest I restart the OlE 
server outside of my application name.

It seems as if there is a problem when there are more than one subform 
because I have never seen this before.

Question How do I restart the OLE Server ? 
         Is there a way to access data on the third form without this 
problem ?

Thanks

How are you trying to access the controls?

Amy

> I have a form, frmMember having 2 subforms, frmDonations and 
f> rmDonationsDetails.

> frmMember 1-m with frmDonations
f> rmDonations 1 -m with frmDonationsDetails

> I am having problems accessing controls on the third form from the main 
f> orm, frmDonationsDetails . I get a error with the Active X or OLE 
server 
s> aying there is problem communicating.  It suggest I restart the OlE 
s> erver outside of my application name.

> It seems as if there is a problem when there are more than one subform 
b> ecause I have never seen this before.

> Question How do I restart the OLE Server ? 
 >         Is there a way to access data on the third form without this 
p> roblem ?

> Thanks

> 

The names of the forms are frmDon, frmDonSub, frmDonSubDetails.  I am 
trying to get the value in a text box named txtAmt in frmDonSubDetails so 
I can sum the values on the form .  This form is in Continuous Forms View.

To get to txtAmt I use  Forms!frmDon!frmDonSubDetails!txtAmt.  A soon as I 
start using the above I start getting the errors described.

 I even tried to have frmDon and frmDonSub as form and sub form and link 
to frmDonSub by the common ID but I still get the same error.  The formula 
works because I can print the values on the main form.

I think it has to do with having 2 subforms.
Hope that is clearer.   
  














> How are you trying to access the controls?

> Amy

> > I have a form, frmMember having 2 subforms, frmDonations and 
f> > rmDonationsDetails.

> > frmMember 1-m with frmDonations
f> > rmDonations 1 -m with frmDonationsDetails

> > I am having problems accessing controls on the third form from the 
main 
f> > orm, frmDonationsDetails . I get a error with the Active X or OLE 
s> erver 
s> > aying there is problem communicating.  It suggest I restart the OlE 
s> > erver outside of my application name.

> > It seems as if there is a problem when there are more than one subform 
b> > ecause I have never seen this before.

> > Question How do I restart the OLE Server ? 
 > >         Is there a way to access data on the third form without this 
p> > roblem ?

> > Thanks

> >