View Single Post
 
Old 02-23-2021, 09:00 AM
roseheller roseheller is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2021
Posts: 3
roseheller is on a distinguished road
Default

Well then, in order of the solutions you gave me:

1. "For a demonstration, see: https://www.msofficeforums.com/word/16379-form-auto-fill-based-different-field-value.html#post46429"

--> When I downloaded the document, I see the Dept drowpdown: HR/Finance... and I also see that there is "Code" and "Location" just below. However, when I click on HR or Finance, nothing happens beyond my selecting those words. Nothing else pops up.
--> I have tried using IF and REF (with the appropriate Form Field CTRL + FN + F9) but they don't seem to work on my version of Word because nothing happens. It just becomes invisible text once I disappear the Form Fields with ALT + FN + F9.

2. "An alternative would be to use Content Controls, plus VBA. For a demonstration, see: https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists.html#post46903"

--> When I select Smiths Wholesales/Roundhouse Nurseries, nothing happens immediately. However, I did notice just now, when I was clicking on the page to copy the text, that text appears below, but only if I click on the empty "Client Details" form.... or if I click TAB (now that I've looked at solution number 3 in greater detail)
--> This seems like the best option for me to use. I'll need to explain it to the company I'm volunteering for, but this might just be what I'll use.

3. "and, for different elements from a selected item to be output to different content controls, see: "https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists-5.html#post120392"

--> Ah... okay, I realize what the problem was. I used the "TAB" click whilst it was still in the form version and also when it was protected but only at the location of the "IF" and "REF" statement... I tried it whilst "Protection is enabled" and it worked.

Please disregard my statement for the 1st solution... this has all been user error on my end. Sorry, I'm really a VBA amateur so this is one heck of a learning curve on my end. Thank you for your patience.

Since I need to create large tables, paragraphs, and indents for each dropdown choice (see screenshot for example) which engineers would need to be able to edit/add information to... what do you recommend?
Attached Images
File Type: png Screenshot (36).png (9.7 KB, 21 views)
Reply With Quote