Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
May 06, 2022
Solved

Subform Calling

Hello Experts,   I have 2 subforms and a helper field I am using to link the 2 subforms: subform1: subfrmFX (in the footer on frmFXTracker) subform2: subfrmRollsChild (in the footer of frmFXTrack...
access
  • arnel_gp's avatar
    arnel_gp
    May 06, 2022
    try:

    =[subfrmRollsChild].[Form]![txtIDRollsPK]
arnel_gp's avatar
arnel_gp
Iron Contributor
May 06, 2022
try:

=[subfrmRollsChild].[Form]![txtIDRollsPK]
Tony2021's avatar
Tony2021
Iron Contributor
May 07, 2022

arnel_gp 

Perfect. Thank you once again for your help! I think the source of my confusion is that I am using an unbound form (frmFXTracker) and in that case its not necessary to reference this unbound form (just the subform names) but if I was using a form with a record source instead of an unbound form, then I would need to reference the form with the record source. I also get confused what to reference (the NAME of the field or the control source.)

 

For anyone else reading this at my level, in the subform's Link Master and Link Child, the master uses the name of the helper field and the Child uses the control source (not the name of the field).

 

 

 

Resources