Reference a field in Footer of Unbound Form

Steel Contributor

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. 

 

 

 

5 Replies
you can use the Base Expression and use it on your Calculation:

=Nz([subfrmFXRollsChild].[Form]![txtAmountRoll], 0) * IIF(IsNull([txtFWPts]), 0, [txtFWPts] / 10000)

@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.  

 

Tony2021_0-1652027482886.pngTony2021_1-1652027537048.png

 

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?
(US)

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

=Nz(

Laila Gibson Leah Francesca and Laila