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 f...
access
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)
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.  

 

 

  • leg034bcpsorg's avatar
    leg034bcpsorg
    Copper Contributor
    May 08, 2022

    Laila Gibson Leah Francesca and Laila

Resources