Reference to calc field on sister subform?

[bhammer]

Acc2003
I have two subforms on my form. The one in Single Form view (sub1) has some
textboxes that I want to display the values of some calculated fields placed
in the footer of the other subform (sub2), which must be in datasheet view
(therefore footer won't show). The calculations are simple Sum and Count.

Q: How can I reference a calculated field in the footer of one subform to
display in the textbox of the sister subform?

I've tried the usual reference in the ControlSource for the textbox on
sub1(=Forms.frmMain.frmSub2.Form.txtSum), but it's not working as desired.
Meaning it is blank until I navigate to another record on sub2.

One more thing that may be relevant: The enitire form works by clicking on a
row in a third subform (datasheet view) which lists Issues, whereby Sub2 then
displays the records tagged with that Issue (through a Master/Child link to
the Main by a hidden txtIssueID.

So upon first selecting an Issue and then showing the records (on sub2), the
calculated fields in the footer do their thing correctly, but don't show-up
in the referenced textboxes (on sub1) until after I navigate to a different
record.

 

[Arvin Meyer MVP]

Me.Parent.NameOfOtherSubformControl.Form.TextBoxName