I have three tables in a form. Users can remove these tables if their not required by pressing a button called 'no'. This sets the table presence to 'hidden'.
I have a button on the form for submit (not an actual submit button) that has some validations on it and then submits by email.
I am working on the assumption that there is an issue with the below code(which occurs on the click event of my button that submits the form) somewhere that is making these things happen, or in the case of my appearing ellipses and fragment, not happen.
I have used this code in other forms, with slight variations, and all seems to work ok although the other forms have not involved an item that has been hidden before.
Just a note: the BankDetails, Print and SaveAs 'hidden' all works ok. Where am I going wrong?
Under Form ... Properties ... Run-Time ... Preserve Scripting Changes, is it set to automatic or manual. Manual will mean that you need to restore the presence values yourself whenever the form is opened. You probably wont Automatic
Thank you! That has resolved the issue with the reappearing table.
I am still struggling with the two other issues however.
I have now noticed that after submission, if I submit the form for a second time, the necessary objects appear. Will it help my cause if I put the necessary presence code in the preSubmit or postSubmit event?