Reference a field in Footer of Unbound Form

%3CLINGO-SUB%20id%3D%22lingo-sub-3337608%22%20slang%3D%22en-US%22%3EReference%20a%20field%20in%20Footer%20of%20Unbound%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3337608%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Experts%2C%3C%2FP%3E%3CP%3EHello%20Experts%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20unbound%20form%20named%20frmFXTracker%3C%2FP%3E%3CP%3EI%20have%20a%20unbound%20field%20named%26nbsp%3BtxtAmountRoll%20in%20the%20footer%20of%20this%20unbound%20form.%3C%2FP%3E%3CP%3EI%20also%20have%20a%20subform%20in%20the%20footer%20of%20frmFXTracker.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20calculated%20field%20in%20this%20subform%20and%20I%20need%20to%20reference%26nbsp%3BtxtAmountRoll%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20what%20I%20have%20but%20I%20get%20a%20%3CSTRONG%3E%23Type%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3E%3D%5BForm%5D!%5BtxtAmountRoll%5D*(%5BtxtFWPts%5D%2F10000)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20reference%20that%20unbound%20field%26nbsp%3BtxtAmountRoll%20in%20the%20above%20calculation%3F%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%26nbsp%3B%26nbsp%3BtxtAmountRoll%20control%20source%20%3D%5BsubfrmFXRollsChild%5D.%5BForm%5D!%5BtxtAmountRoll%5D.%20Not%20sure%20if%20I%20have%20to%20reference%20this%20calculation%20instead%20of%20the%20name%20of%20the%20field%20txtAmountRoll.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3337608%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3339191%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20a%20field%20in%20Footer%20of%20Unbound%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339191%22%20slang%3D%22en-US%22%3Eyou%20can%20use%20the%20Base%20Expression%20and%20use%20it%20on%20your%20Calculation%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DNz(%5BsubfrmFXRollsChild%5D.%5BForm%5D!%5BtxtAmountRoll%5D%2C%200)%20*%20IIF(IsNull(%5BtxtFWPts%5D)%2C%200%2C%20%5BtxtFWPts%5D%20%2F%2010000)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3340076%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20a%20field%20in%20Footer%20of%20Unbound%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1228265%22%20target%3D%22_blank%22%3E%40arnel_gp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Arnel%2C%3CBR%20%2F%3Ethanks.%20I%20seem%20to%20have%20a%20%23Name.%3CBR%20%2F%3EIt%20has%20something%20to%20do%20with%20this%20part%3A%3CBR%20%2F%3ENz(%5BsubfrmFXRollsChild%5D.%5BForm%5D!%5BtxtAmountRoll%5D%2C%200)%3CBR%20%2F%3EI%20know%20its%20this%20part%20since%20I%20removed%20all%20else%20and%20get%20the%20%23Name.%3C%2FP%3E%3CP%3EI%20checked%20the%20names%20and%20they%20are%20correct.%3C%2FP%3E%3CP%3EWhy%20do%20you%20think%20I%20still%20get%20a%20%23name%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20very%20much.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tony2021_0-1652027482886.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370047i0FFCFD523FFA4783%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Tony2021_0-1652027482886.png%22%20alt%3D%22Tony2021_0-1652027482886.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tony2021_1-1652027537048.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370048iEC13BEFA13C2658B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Tony2021_1-1652027537048.png%22%20alt%3D%22Tony2021_1-1652027537048.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3340081%22%20slang%3D%22es-ES%22%3ERe%3A%20Reference%20a%20field%20in%20Footer%20of%20Unbound%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340081%22%20slang%3D%22es-ES%22%3EBelow%20is%20what%20I%20have%2C%20but%20I%20get%20a%20%23Type%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%5BForm%5D!%20%5BtxtAmountRoll%5D*(%5BtxtFWPts%5D%2F10000)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20I%20reference%20that%20unbound%20field%20txtAmountRoll%20in%20the%20calculation%20above%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3340082%22%20slang%3D%22es-ES%22%3ERe%3A%20Reference%20a%20field%20in%20Footer%20of%20Unbound%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340082%22%20slang%3D%22es-ES%22%3E(US)%3CBR%20%2F%3E%3CBR%20%2F%3E%20you%20can%20use%20the%20base%20expression%20and%20use%20it%20in%20your%20calculation%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DNz(%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3340086%22%20slang%3D%22es-ES%22%3ERe%3A%20Reference%20a%20field%20in%20Footer%20of%20Unbound%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340086%22%20slang%3D%22es-ES%22%3E%3CP%3ELaila%20Gibson%20Leah%20Francesca%20and%20Laila%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super 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