I have a multiple select list box with only 3 entries. I have been trying, with no luck, to program it so that when one specific entry is selected that a subform is made visible.
I have entry 1, 2, and 3 and if 2 is chosen then the subform is visible. I got that piece to work but if 1 and 2 or 2 and 3 or 1 and 2 and 3 are chosen then the subform is made visible otherwise it stays hidden.
I feel like you may be making this more complex than it needs to be. Instead of writing all of those IF statements, why can't you just say "if the specific selection is selected" make the subform visible. You should be able to use indexes to programatically refer to the item in the list box you need. As long as you aren't dynamically populating the list box you should be fine. Also, Paul is right, newText won't work there.