See also:
Dependent Dropdown Content Controls
Help with cascading dropdown list

Hierarchical Dropdown Content Controls


Creating a reducing drop down list

Dependent Text Content Controls
Multiple entries in dropdown lists

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Macropod thank you so much! I was able to copy-paste your VBA code from Dependent dropdown CC and just by changing the labels, it worked perfectly!

2 quick questions:

1. In this form I'm updating, I still want the next 2 fields to update but these are much simpler. I want something to the effect of "IF 'Eliquis', THEN '1 by mouth twice a day'' IF 'Orencia', THEN....." How do I do that or add that into the code?

2. Where can I go online to learn more about VBA and how to develop it myself?

That suggest you need to incorporate the principles from the 'dependent text' example I provided a link for.
There are many such resources, including code samples on forums such as this. The quality is variable; avoid anything that uses lots of 'Selection', 'ActiveWindow.ActivePane.View.SeekView' and 'ChangeFileOpenDirectory' code, as that usually evidences heavy reliance on the macro recorder.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hey Macropod!

Thank you again for all your help! I have one final question for you though if you don't mind!

Here is a copy-paste of the section I've been working on:

Product Information:
Drug: Sprycel
Strength: Choose an item.
Dose: { IF { REF Drug \* MERGEFORMAT } = "Eliquis""1 by mouth twice a day""{ IF {REF Drug \* MERGEFORMAT } = "Orencia""Inject once under the skin once a week"" { IF {REF Drug \* MERGEFORMAT } = "Sprycel""1 by mouth once a day"}""}"" }
Route: {IF {REF Drug \* MERGEFORMAT } = "Eliquis""Orally""{ IF {REF Drug \* MERGEFORMAT } ="Orencia""Subcutaneous""{IF {REF Drug \* MERGEFORMAT } ="Sprycel""Orally"}""}"" }

When I hit alt-F9 both the dose and route disappear and just say "REF". If I select a drug, nothing happens in these fields. Can you advise why? The drug and strength fields are content control that you helped me with previously.

Thank you