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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Options and associated labels 4
Option Groups: Can I Group the Buttons AND the Box They're In? 2
Names of individual controls in option group 4
Printing From Option Groups 4
Option Group Mods 5
I have an Option Group on my form already. What is the object name 2
Option groups causing form corruption 2
Access Create option group without using wizard? 2

Back
Top