Subform Calculated field to another subform

[tareyj8569]

Can you call a calculated unbound Subform from field from Subform 1 to another unbound Subform field in Subform 2?


I have 1 mainform and 2 subforms
I can get the field to show on my mainform from Subform 1but not my 2nd subform.

=[overview subform].[Form]![Text103] < works on main form but not my 2nd subform

=[Forms]![Overview mainform]![overview subform].[Form]![Text103] <does not work on my 2nd subform.

Hope that wasn't too confusing, thanks for your time and help.

[InsuranceGuy]

It's a bit different once you're referring to subforms. Instead of referring to the subform by name, you should refer to the subform by the subform's control name on the main form.

The appropriate reference pattern is:

[Forms]![MainFormActualName]![SubFormControlName].Form.[ActualControlNameDesired]

You'll note that I indicated SubFormControlName, not the subform's design name from the forms list. It's critical to referencing using the control name as defined on [MainFormActualName].

[June7]

I always give subform/subreport container control a name different from the object it holds, like ctrSub1. Then reference the container control name.

=[Forms]![Overview mainform].ctrSub1![Text103]

[InsuranceGuy]

Couldn't agree more June. Great best practice.

Jeff

[June7]

Jeff, I did not see your post first - great minds ...

[tareyj8569]

I don't know if I am doing something wrong or what but I keep getting 0 in my 2nd subform.

Subform 1 shows 50%
=Sum(IIf([Pass or Fail]="Pass" And [Location]="purple",1,0))/IIf(Sum(IIf([Location]="purple",1,0))=0,1,Sum(IIf([Location]="purple",1,0))) <this is my unbound calculated field

Subform 2 shows 0%
=[Forms]![Overview Mainform].[ABC_overview_subform]![text103] < put on unbound 2nd subform does not work
=[Forms]![Overview mainform].ctrSub1![Text103] <was the example

Mainform shows 50%
=[ABC_overview_subform].Form!Text103 < on unbound mainform works

If I am misunderstanding sorry.

[tareyj8569]

tried to edit post but would not post, but wanted to add - also access automatically puts the brackets on the ABC_overview_subform when I leave them off.

[InsuranceGuy]

Do you want to attach your db?