Set (Same) Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All
i am trying to Set the same value for different values of other control.
If the user picks any one of these particular listed values, then the other
control is set to "0"
I tried using
Conditon: [NameOfControl]="04" Or "05" Or "06" Or "11" Or "13" Or "14" Or
"15" Or "16" Or "17" Or "18" Or "20" Or "29"
Action: SetValue
Item: [NameOfYourOtherControl]
Expression: 0

the macro works only for the first value (04)

Should i have to proceed this way for every value of the Primary Control or
is there any other easier way to get the same results.

Condition: [NameOfContol]="04"
Action: SetValue
Item: [NameOfYourOtherControl]
Expression: 0

Condition: [NameOfControl]="05'
Action: SetValue
Item: [NameOfYourOtherControl]
Expression: 0

Thanks
Sara
 
You have to repeat the full expression for each number:

Conditon: [NameOfControl]="04" Or [NameOfControl]="05" Or
[NameOfControl]="06" Or [NameOfControl]="11" Or [NameOfControl]="13" Or
[NameOfControl]="14" Or [NameOfControl]="15" Or [NameOfControl]="16" Or
[NameOfControl]="17" Or [NameOfControl]="18" Or [NameOfControl]="20" Or
[NameOfControl]="29"
 
Sara,

As an alternative to Ken's suggestion, I think this should also work...

[NameOfControl]
In("04","05","06","11","13","14","15","16","17","18","20","29")
 
Back
Top