Select in Field Trigger (Using expression)

[zagzebski]

I am trying to  assign a variable.in a field event.

The following expression returns the required value when viewing in a text box but when I try to assign "on select" in a field event it will not update the variable.

=trim(purgechar(if(vDeepSellPolicyChoice1=vDeepSellPolicyChoice2,vDeepSellPolicyChoice2,replace(vDeepSellPolicyChoice2,vDeepSellPolicyChoice1,',')),','))

Any thoughts?

Steve

[sunny_talwar]

Would you be able to share a sample to look at this?