Set (Same) Value

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
 
K

Ken Snell \(MVP\)

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"
 
S

Steve Schapel

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top