You were certainly overthinking when you created that form.
Sometimes I find it stimulating to modify such forms, and this one was such a challenge. It was however relatively simple to extract your tables, once I found how you hid them, make them autotext entries and create a userform to call them based on the logic in your document.
As there are 8 such tables hidden in your form and there are nine possible options, I assume that the first item in your combo box is a prompt. In which case, the attached should be closer to what you had in mind.
Create a new document from the template to open the userform and there's a button on the Home tab should you wish to change the options (before you have completed the tables).
I would recommend that you replace the legacy form fields with content controls, as they are much faster to process. There are tools on my web site to help you do that http://www.gmayor.com/insert_content_control_addin.htm however my altrusim only stretches so far, so I will leave that to you
Reply With Quote
