Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
May 07, 2022

Reference a field in Footer of Unbound Form

Hello Experts,

Hello Experts, 

 

I have an unbound form named frmFXTracker

I have a unbound field named txtAmountRoll in the footer of this unbound form.

I also have a subform in the footer of frmFXTracker. 

I have a calculated field in this subform and I need to reference txtAmountRoll 

 

Below is what I have but I get a #Type:

=[Form]![txtAmountRoll]*([txtFWPts]/10000)

 

How can I reference that unbound field txtAmountRoll in the above calculation? 

Note:  txtAmountRoll control source =[subfrmFXRollsChild].[Form]![txtAmountRoll]. Not sure if I have to reference this calculation instead of the name of the field txtAmountRoll. 

 

 

 

access
  • leg034bcpsorg's avatar
    leg034bcpsorg
    Copper Contributor
    May 08, 2022
    continuación se muestra lo que tengo, pero obtengo una #Type:

    =[Forma]! [txtAmountRoll]*([txtFWPts]/10000)



    ¿Cómo puedo hacer referencia a ese campo no enlazado txtAmountRoll en el cálculo anterior?
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    May 08, 2022
    you can use the Base Expression and use it on your Calculation:

    =Nz([subfrmFXRollsChild].[Form]![txtAmountRoll], 0) * IIF(IsNull([txtFWPts]), 0, [txtFWPts] / 10000)
    • leg034bcpsorg's avatar
      leg034bcpsorg
      Copper Contributor
      May 08, 2022
      (US)

      puede usar la expresión base y usarla en su cálculo:

      =Nz(
    • Tony2021's avatar
      Tony2021
      Steel Contributor
      May 08, 2022

      arnel_gp 

      Hi Arnel,
      thanks. I seem to have a #Name.
      It has something to do with this part:
      Nz([subfrmFXRollsChild].[Form]![txtAmountRoll], 0)
      I know its this part since I removed all else and get the #Name.

      I checked the names and they are correct.

      Why do you think I still get a #name?  

       

      thank you very much.  

       

       

Resources