Hi please could someone help me

I have created a form for a client and it has many columns in a table

In column A if they user selects NO column B and C must say YES
But if the user selects YES in column A then they will be able to choose YES or NO for both column B and C



Please help with this?

Presumably, you're using some form of Dropdown for the Yes/No choices. Is it a formfield, content control, something else?

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

Hi yes I have used content controls for the drop downs

See attached implementation. The process uses a ContentControlOnExit macro, which you can access via Alt-F11.

Attached Files

CCtrl - Conditional Locking.zip (35.2 KB, 33 views)

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

Thanks so much it works like a dream