Field Event Trigger, Action

[#1]

Hello,

I'm trying to use field event triggers to deselect fields based on the value of another field.

It's not working, tho.

Needed Logic: When the UpSegment field is selected, if the only selection is 'K12' then clear the Col_Rep field

On Select, UpSegment, Select in field, Col_Rep

The search string looks like this:

=If(only(UpSegment) = 'K12','', ????? )

what should the else look like (preventing any selection change)? am i doing this right ?

Would it be better to do it with a Macro ? Can someone please provide a macro example for this ?

Thank you in advance !

Tim