Totals from Sub Forms 2

[gavinjb]

hi,

I am trying to display totals which are calulated in hidden fields on my subform (fsubSalesDetails), on my main form, but I seem to be doing something wrong as all I get is an error in the text box, if I run the sub form on its own and show the total fields they work fine.

The string I am placing in the Text boxes on the main form, does anyone have any ideas what I am doing wrong

=[Forms]![fsubSalesDetails]![UnitPriceGT]
=[Forms]![fsubSalesDetails]![TotalPriceGT]

 

[RoyVidar]

Hi!

Referring to subform controls from main form, could be done this way:

[tt]=Forms![frmFainForm]![fsubSalesDetails].Form![UnitPriceGT][/tt]

Here's a Microsoft link on How to Refer to a Control on a Subform or Subreport

You'll need to use the subform control name, which might differ from the name of the subform as vieved in the database window.

Roy-Vidar

 

[yduckfr]

It should be
= Me.[subform control name].Form![UnitPriceGT]
= Me.[subform control name].Form![TotalPriceGT]
(with Subform control name I mean not the name of the subform, the name of the subform control on the main form)