May 07 2022 08:50 AM
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.
May 07 2022 10:43 PM
May 08 2022 09:33 AM
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.
May 08 2022 09:37 AM
May 08 2022 09:38 AM
May 08 2022 09:39 AM
Laila Gibson Leah Francesca and Laila