Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group of Option Buttons - Chose only one

Status
Not open for further replies.

Cabrita

Technical User
Apr 3, 2002
140
PT
Hi,

How can I have a group of options buttons in a form and the user can only chose one button from the group?

Thank you very much

Andre
 
Hi Andre!

Put the option buttons in a frame control and Access will take care of the rest. Check help to learn more about frame controls and if you have some specific questions just post back here.

hth


Jeff Bridgham
bridgham@purdue.edu
 
Hi Jeff,

My help when I put frame control gives pictures information, not about option button, can you help me on how to put the option button on a frame?

Thanks

Andre
 
Hi!

In the tool box the control looks like a rectangle with an XYZ at the top. Drag one of these controls (alternatively called Option Group or Frame) and a wizard should start that will walk you through the set up.

hth


Jeff Bridgham
bridgham@purdue.edu
 
Sorry jebry,

I didn't manage to find the wizard, it's possible that I don't have it instaled? Is there a manual way to do it?

Andre
 
Hi!

Certainly. Just add the option group to your form and then add the buttons to the option group. Now only one button will allowed to be selected. When a button is selected the value of the frame will be the option value of the button. Look on the data tab of the property sheet for the buttons in the option group control to see the option value property. Now you can change the option values of the buttons to match values you need, if the values are not important then leave them as they come up (the first button will be 1, the second 2, etc). You can right code to check the value of the option group and make changes as necessary. For instance, if you are using an option group to imput gender, you can check the value in the After Update event for the group and store either Male or Female depending on what was checked.

hth


Jeff Bridgham
bridgham@purdue.edu
 
Make sure that your wizard button is clicked!

In design view, immediately to the left of the label button, "Aa", is a magic wand and stars/fairy dust(?) (It is Christmas!)

Make sure that is clicked down to activate wizards when you add controls.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top