Hi areriff,

The following assumes you're using legacy formfields.

You need a different approach for the second field. Instead of using a formfield, use ordinary IF fields coded as:
{IF {REF DROPDOWN1}= "John" "eating"}{IF {REF DROPDOWN1}= "Chris" "dancing"}{IF {REF DROPDOWN1}= "Abdul" "cooking"}
where 'DROPDOWN1' is the internal bookmark name assigned to your dropdown formfield. No vba is required. All you need to do is to check the Dropdown formfield's 'calculate on exit' property.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

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