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?