Creating a calculated control in Subform and Main form

[Guest]

My question.
Data I need is the total of the Rental Amount to come up on the main form
when selecting the different rental units on the main form.
I have entered in the footer of the subform which is named RentalUnitSubform.
No label name
Name: txtRentalAmountSum
TextBox: =Sum(RentalAmount])
Main Form:
Lable Name: lblRentalAmountTtl
Caption: Total Monthly Income:

Text Box Name: txtRentalAmountTtl
Control Source: =RentalUnitSubform.Form!txtRentalAmount
I am new at this but I have spent many hours changing names adding or taking
away names.
I sure hope someone can help.
Thanks,
Renae

 

[Brian Bastl]

Renae,

Looks like you were close. I believe that the control source for
txtRentalAmountTtl should be:

=RentalUnitSubform.Form!txtRentalAmountSum

Brian

 

[Guest]

Thanks Brian, but that didn't work either.
--
Renae

Renae,

Looks like you were close. I believe that the control source for
txtRentalAmountTtl should be:

=RentalUnitSubform.Form!txtRentalAmountSum

Brian

My question.
Data I need is the total of the Rental Amount to come up on the main form
when selecting the different rental units on the main form.
I have entered in the footer of the subform which is named RentalUnitSubform.
No label name
Name: txtRentalAmountSum
TextBox: =Sum(RentalAmount])
Main Form:
Lable Name: lblRentalAmountTtl
Caption: Total Monthly Income:

Text Box Name: txtRentalAmountTtl
Control Source: =RentalUnitSubform.Form!txtRentalAmount
I am new at this but I have spent many hours changing names adding or taking
away names.
I sure hope someone can help.
Thanks,
Renae

 

[Brian Bastl]

Are you using the Expression Builder, or are you just typing it in? Are you
sure that 'RentalUnitSubform' is the name of the subform control? It may or
not be the same as the name of the subform.

Brian

Thanks Brian, but that didn't work either.
--
Renae

Renae,

Looks like you were close. I believe that the control source for
txtRentalAmountTtl should be:

=RentalUnitSubform.Form!txtRentalAmountSum

Brian

My question.
Data I need is the total of the Rental Amount to come up on the main form
when selecting the different rental units on the main form.
I have entered in the footer of the subform which is named RentalUnitSubform.
No label name
Name: txtRentalAmountSum
TextBox: =Sum(RentalAmount])
Main Form:
Lable Name: lblRentalAmountTtl
Caption: Total Monthly Income:

Text Box Name: txtRentalAmountTtl
Control Source: =RentalUnitSubform.Form!txtRentalAmount
I am new at this but I have spent many hours changing names adding or taking
away names.
I sure hope someone can help.
Thanks,
Renae

 

[Guest]

Yes it is the name of the subform/subreport. I checked. I am just typing it
into the text boxes.
--
Renae

Are you using the Expression Builder, or are you just typing it in? Are you
sure that 'RentalUnitSubform' is the name of the subform control? It may or
not be the same as the name of the subform.

Brian

Thanks Brian, but that didn't work either.
--
Renae

Renae,

Looks like you were close. I believe that the control source for
txtRentalAmountTtl should be:

=RentalUnitSubform.Form!txtRentalAmountSum

Brian

My question.
Data I need is the total of the Rental Amount to come up on the main form
when selecting the different rental units on the main form.
I have entered in the footer of the subform which is named
RentalUnitSubform.
No label name
Name: txtRentalAmountSum
TextBox: =Sum(RentalAmount])
Main Form:
Lable Name: lblRentalAmountTtl
Caption: Total Monthly Income:

Text Box Name: txtRentalAmountTtl
Control Source: =RentalUnitSubform.Form!txtRentalAmount
I am new at this but I have spent many hours changing names adding or
taking
away names.
I sure hope someone can help.
Thanks,
Renae