Subform Totals

[srideout2525]

Another quick one.

On my order form I have multiple Rates displayed in a subform. I total these rates in the footer.

I want to use that value in the main portion of the form, for other calculations. Is there a way to have that value automatically appear in another text box on the main form? I know once the value calculates I could have an unbound txt box and type it, but I'd like to skip that step!

Just some background. These rates are from a wholesale stand point, the total value will than have a profit and tax related to the which will get charged to the customer. Not sure I needed to write that, but just may give you the understanding why im doing it this way.

Thx

 

[Robert Dunstan]

Create an unbound text box and it's control source you reference your subform's total

=([frmYourSubFormName].[Form]![txtYourControlName])

 

[srideout2525]

I did as you said. No luck.

sfrmARR ( thats my sub form)

txtRateTotal ( thats the text box on the subform that the rates are totalled in)

txtBaseRate ( this is the unbound text box on my main form)

The control source I have written as follows:


=([sfrmARR].[Form]![txtRateTotal])


=([frmYourSubFormName].[Form]![txtYourControlName])


Any suggestions..Im still messing with it

 

[srideout2525]

HAHAHA

Ignore..I'm obviously not all there. My error. In fact, I have named my subform sfrmARR, but I tried the expression builder and it is calling it Child15, so oh well....it works

Thanks for the help!!!!


Check out my other recent post...maybe you can solve it

Thx again