There is a RadioButtonList that depending on the option (1,2,3), will open a Subform (1,2,3). Each Subform contains a different set of checkboxes. The checkboxes for each Subform (1,2,3) are tied to a different Subform (5,6,7). Subforms 5, 6, and 7 all contain tables. The checkboxes in Subforms 1, 2, and 3 are tied to the rows in the tables in Subforms 5, 6, and 7. All rows of all tables are set to "hidden". When checking a checkbox, the associated row of the associated table has its presence changed to "visible".
RadioButtonList1 = 1
Subform1 is displayed.
CheckBox3 = 1
Subform5.Table1.Row3 is displayed.
This all works perfectly. I am sure it is convoluted, but the end result works.
Here is what I need: I need a way to re-hide whatever was set to "visible". Here is what I have tried:
It clears the contents of the table, but does not hide it from view. I don't want to have to manually set all table rows to "hidden" - there are 156 of them (don't judge me!). Is there a script that can find any rows that are not hidden, and re-hide them? Thanks in advance.
Ok. I have figured this out. I am not sure why it works, but I am sure that it works. I tried moving the script from the CheckBox to the Row of the table. I think because the field is referencing a different field (rather than itself) in the "if" part of the statement, that is what allows it to work. If someone could provide an explanation as to why, that would still be awesome!