Updating Calculated controls on Subforms

[jambet]

I have a tabbed subform (frmProd) (the secondary tab) that contains a calclulated control (weight) using data from a subform (frmWeights)on the frmProd subform. I am able to calculate these controls by using the ctlJob_GotFocus event with the following code, this being the first control to get focus when frmProd is opened independently of its parent.

Me.[10XIWeight] = Forms![frmProd]![frmWeights]![10XIwt] * Me.[Ctl10ft_XI]

However, when I open the parent form, frmJob, I cannot get the calculated control on frmProd to update. I have tried pasting the above code into the Activate, Current, GotFocus, Load, Open, and Resize events for frmProd and get either an error msg (Can't find frmProd) or no action whatever.
Maybe I am making this too difficult or just maybe I don't know what I'm doing, but I would appreciat any help I can get. I apologize for the length of this explanation.

 

[TheAceMan1]

jambet . . .

In the onCurrent event of the approrpriate form try [blue]Me.ReCalc[/blue] . . .

See Ya! . . . . . .

 

[jambet]

Thanks, AceMan. Tried the recalc with no positive result. I'll keep looking

 

[PHV]

And what about this ?
Me![10XIWeight] = Me![frmWeights].Form![10XIwt] * Me![Ctl10ft_XI]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886