Option Group Help

[bxc4904]

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.

 

[stopher]

I'm not sure I understand what you are asking.

Do you mean that if the checkbox group has a value of 3 then you want checkbox number 3 on your report to be shown as ticked? Where does the related text box come into it?

If I'm on the right lines then you can put the following in the control source for checkbox 1 on you report:
=IIf([myValue]=1,True,False)

And in checkbox 2:
=IIf([myValue]=2,True,False)

etc

myValue can refer to any other report field so if it's text then:
=IIf([myText]="the text corresponding to 1",True,False)
etc

hth
Stopher

 

[bxc4904]

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