How to address a control on a subform (from the main form)?

[Sanjin Vidlanovic]

Is it possible to address a specific control on a subform from the main
form.



On the subform I have a control (subform footer) that contains a sum of
records shown in the detail section.



I would like to use that value on the main form (to calculate
ValueOnTheMainForm - SumOfValuesOnTheSubform)





Thx



Sanjin

 

[James Goodman]

Yup,

Forms!frmName!SubFormName!ControlName



--
Cheers,


James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures

 

[Sanjin Vidlanovic]

Yup,

Forms!frmName!SubFormName!ControlName



--
Cheers,


James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures

Thx, I've misspelled the control name -that's why it didn't work the first
time (and I thought the addressing was wrong).



Sanjin