Reference a field in Footer of Unbound Form

Super Contributor

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.

5 Replies

Re: Reference a field in Footer of Unbound Form

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

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

Re: Reference a field in Footer of Unbound Form

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.

Re: Reference a field in Footer of Unbound Form

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?

Re: Reference a field in Footer of Unbound Form

(US)

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

=Nz(

Re: Reference a field in Footer of Unbound Form

Laila Gibson Leah Francesca and Laila