option group

[RMB]

I have a form and I created an option group. Based on the option selected,
how can I get the data on the label to print on my report based on my
selection?

Thanks...

 

[KARL DEWEY]

You can use IIF statement in your query or join a table that has fields for
the option number and label.

 

[John Hawker]

If you click on an option button, it's OptionValue property (Data tab in
Property Sheet) gets assigned to the Value property of the Option Group.
Create a textbox in your report that references the Option Group value
property.