I’ve a requirement of displaying various subforms based on a field value. Suppose if the field is 0, “subform0” has to be displayed and if it is 1, “subform1” has to be displayed.As the computed subforms are not dynamic ie., the formula for the computed subform is calculated only at the time of opening of the document, I’ve used sections instead.
I’ve placed subform0 in “sec0” section, “subform1” in “sec1” and so on. In the hide-when formula for “sec0”, the condition is flag!=0 and so on. But when I click the button which changes the flag value and refreshes the document, the section is hidden but the subform is visible.
Can someone help me out? Thanks in advance.
Subject: Subforms and hide-when formulas
Hi satish, Plz make sure that the section is always in Collapsible mode.If the Section is in Expand mode and when u run the form u can see the section hidden,but the content which is under the section will be visibel.So plz always make sure that the section is in collapsible mode.Just try this .
Subject: RE: Subforms and hide-when formulas
Hi Ranjit, thanx for the prompt response. It works. But the users always want the sections to be expanded, right? Also, if the users manually expand the section when it is visible(when the field is having the proper value), and then they click the button, the same problem of the subform being visible reappears.
Subject: RE: Subforms and hide-when formulas
If there is no better design to fulfill the business need, you might consider using a programmatic table instead of sections.
Works pretty well.