Reference a field on the subforms formfooter?

[neemi]

I am trying to set the control source for a field on the subforms footer and need help. It needs to be in the footer as it is a totals calculation of a continuous form.

So far I have the below code....

Me.subform.formfooter.Controls("SumCol" & i).ControlSource = some calculation

I also need to be able to change the control backcolor on the form footer.

I know this is wrong as it does not work... could someone please help me acheive what I need.. Thanks in advance.

Neemi

 

[Remou]

Is it necessary to set the control source from code? Controls in the footer of subforms are intended for totals etc.

The control source should read something like:

=Sum([SomeField])

To refer to the control, from the main form, use the normal subform referencing:

Me.[NameOfSubFormControl].Form.[NameOfControl].nameofproperty

 

[neemi]

ignore the controlsoursce thing. i have changed my approach for my task at hand.

I have two views on my continuous form... a daily view and a weekly view.

On selecting the each view the corresponding controls are set to visible and vise versa.. They each have the totals on the footer. but i can't manage to turn the visble property on the footer controls on and off accordingly.???

 

[Remou]

What code did you try?

 

[neemi]

PLERASE IGNORE >>> IT WAS MY DUM MISTAKE >>> SPELLING ERROR!!!! DUH!!!
Thanks for your help!!