option group

  • Thread starter Thread starter RMB
  • Start date Start date
R

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...
 
You can use IIF statement in your query or join a table that has fields for
the option number and label.
 
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.
 
Back
Top