Formula not working on repeating Subform
I have a Subform with repeating Rows and a Formula that displays the Value from a different Subform Control.
My problem is the Formula only works on the first Row. I have tried:
- adding a Rule to Set Field Value
- using {*}/{this} on both Formula and Rule
- executing Rule on Form load
I don't know what else to try, and i don't understand why it wouldn't just work on subsequent rows...
-
I set the Currency Code (CAD, USD) for a Client on Subform 1, with other Client Details; then I want that currency code to display next to each row of repeatable Subform 2 where I will enter each invoice amount separately.
p.s. This is how it was working in v5; however, it seems v6 has an issue with it... i might need to find a different way.
-
Oh, you have two different subforms. Try putting the formula in the same subform.
See this topic for more details:
Please sign in to leave a comment.
Comments
3 comments