Display Option Group - Check Boxes

[Navyguy]

Hello All

I wish those of you down south or with friends and family there best wishes.

I am searching for a way to display an option group (Check Boxes) selection in a report. My example:
On a form I have an option group (Check Boxes), lets say “Participate”=(1) and “Did Not Participate”=(2)
On the report I want to display two separate boxes in two separate lines the statement above with the appropriate check box indicated:
Participated (Check Indicated)
Did Not Participate (Check Not Indicated)
Any search tips would be helpful. I have looked through my books and online, but can’t seem to extract how to do this.

As always thanks for your assistance.

 

[Meltdown]

It's quite simple, just drop two checkbox controls onto your report, set the control source of each check box to...

=IIf(Forms!Your_Form_Name.Option_Group_Name=1,True,False)

and the other to

=IIf(Forms!Your_Form_Name.Option_Group_Name=2,True,False)

 

[Navyguy]

Thanks allot, I will give it try.

It seems to be funny how something so simple tends to elude us...

Cheers!