Creating a calculated control in Subform and Main form

R

Renae

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
 
B

Brian Bastl

Renae,

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

=RentalUnitSubform.Form!txtRentalAmountSum

Brian
 
R

Renae

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


Brian Bastl said:
Renae,

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

=RentalUnitSubform.Form!txtRentalAmountSum

Brian

Renae said:
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
Click to expand...
Click to expand...
 
B

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

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


Brian Bastl said:
Renae,

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

=RentalUnitSubform.Form!txtRentalAmountSum

Brian

Renae said:
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
Click to expand...
Click to expand...
Click to expand...
 
R

Renae

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


Brian Bastl said:
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

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


Brian Bastl said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top