How do you reference a field on a Form Footer from a subform

[richmond88]

I have a field called txtSubjectsTotal in the FOOTER of a form called frmXCurricularStudentFeedback.

I am trying to add the contents of that field to another field in the footer of a subform. All I get is the total in the subform field - any help appreciated.

Thanks

Chris

 

[mordja]

richmond88,

Set the control source of the field in your subform to

=[Forms]![frmXCurricularStudentFeedback]![txtSubjectsTotal]

Mordja

 

[TheAceMan1]

How are ya richmond88 . . . .

If the subForm is on frmXCurricularStudentFeedback try in the [blue]ControlSource[/blue] of the textbox on the subform:

[blue] =Forms!frmXCurricularStudentFeedback!txtSubjectsTotal[/blue]

See Ya! . . . . . .

 

[KenReay]

Or

Parent.ControlName

perhaps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[richmond88]

Tried all of those fellas and it just dowsnt show up.

Ill try and explain it a little better

I have a main form - which includes a dfetail line - in the footer of that form it adds one of the fields that is in the detail how I want it.

Also in the footer I have a sub form - on that subform footer I total a field from the sub form detail section.

I then want to add the 2 totals and stick the answer in the footer of the sub form.

All I get is the total of the subform and not the main form.

 

[TheAceMan1]

OK richmond88 . . . . .

Try:

[blue] =Forms!frmXCurricularStudentFeedback!txtSubjectsTotal + [subFormControlName][/blue]

See Ya! . . . . . .

 

[randy700]

As the control source of your text box, have you tried...

= Me.SubformTextboxName + Forms!frmXCurricularStudentFeedback!txtSubjectsTotal


Randy