Select All Values and exclude a Value on a List Box

[#1]

Hi all,

When the qvw document opens, I need select All values and exclude a determinate Value on a List Box. Is it possible with a trigger or a macro? or other way?

Thanks,

Ricardo

[#2 · Accepted solution]

You can use triggers. See attached.

[#3]

Perfect! Thanks.

Now I have other question (+10 points) How can I Select All and exclude two o more values?

Regards,

Ricardo

[#4]

Same way. You just have to use a vertical bar. See attached.

[#5]

I did not know.

Thanks Rebecca! it Works.

But I can give you other 10 points, the forum doesn't allow. I thought I could do. I will check "Useful Answer". I owe you 5 points.

Thanks,

Ricardo

[#6]

Glad I could help.

[#7]

ha ha ha, other 5 points!