Search results

Wayne, The reason I hadn't tried select case is that I thought it would only do true/false on one condition. That sounds even easier. Thanks. Bruce

Thanks to both of you. For now I think I'll try the Or route since it's not much different from what I'm familiar with. I'm going to have to go to my experimental db and practice with the CtrlSet, though. That looks interesting. Either way this will save me a lot of time and space in the future.

I've written the code below to change the Tab Stop and Visible properties of some of my controls based on the value returned from a combo box. The code is on the On Update event of the combo box. As you can see there are only 2 different resulting sets of actions for 7 different values. Is it...

That's exactly what I meant. Thanks for the help. Next time I'll try to be clearer in my wording.

I have an Option Group on a form with 4 check boxes. Is there a way to have the value of the related text box translate into check boxes on a report via VBA? I need the option group for statistical analysis, but I'm not allowed to change the printed report format.

Use a list box and set the Multi Select property to Simple or Extended. Check out "Making Sense of List Boxes" at fontstuff.com.