calling a value from form to subform

[legendv]

How do you call a value from a form into a subform.

I have a form with a query calculated value of Days. There is a subform on this form with other values that need the days value for other calcs.

I'm thinking,
*in the subforms footer*
*in a textbox* formated to percent*
([subformfield] / [mainform]!Days)

Any ideas?

 

[Rich]

=[MainformName]![Textbox]

 

[legendv]

Thanks Rich,
But that's what I'd tried, and when form is displayed it shows vaule #Name?

=Sum([pushchange])/[push]![days]

[pushchange] is query calculated
[push] is name of mainform from qryPerson
[days] is value on mainform from qryPerson

I tried
=Sum([pushchange])/[push]![days]
=Sum([pushchange])/[qryPerson]![days]
=Sum([pushchange])/[tblPerson]![days]

What am I missing?

 

[legendv]

You know I can get the values from the subform onto the mainform, but not vice-versa. But I need it to go the other way.
I need a value on the main form to calc a value on the subform.

[This message has been edited by legendv (edited 06-04-2002).]

 

[legendv]

Forms!Mainformname!Mainformfield

That worked now! I forgot to list Forms!