Topics Search

Using the Option Group Control

Using the Option Group Control
Views: 894
Learn how to Use the Option Group Control in MS-Access Forms. (video tutorial)
Sponsored Links:

Similar posts...

 

No way to tab stop on option button within group?

No way to tab stop on option button within group? Icon
This property doesn't apply to check box, option button, or toggle button controls when they appear in an option group. It applies only to the option group itself.

So this really hinders my ability to just tab through my form, as I have an option group and it is quite pivotal to the form. Any other ways around this? I guess I could take the optionbutton's out of the option group and put some code behind them to see if one is selected to deselect the other one,
 

Using an Option Group to Filter a Microsoft Access Form

Using an Option Group to Filter a Microsoft Access Form Icon
You can use an option group on a Microsoft Access form, report, or data access page to display a limited set of alternatives.
An option group makes selecting a value easy because you can just click the value that you want.
Only one option in an option group can be selected at a time.
In a form or report, an option group consists of a group frame and a set of check boxes, option buttons, and toggle buttons.
 

Multiple option groups and drop-down filters

Multiple option groups and drop-down filters Icon
I developed a report menu that uses an option group to determine the report type, and then based on the option selected, can result in the need for the user to further define the query criteria by selecting say an employee name from a drop-down, and even possibly further define the expected results by picking a date range using the calendar control.

Works great, however I have the need to expand on the current menu.

I guess without going overboard, I am wondering if there are limitations to how many of these "building blocks" can be selected, without the who stack falling over.

For example, selecting report option 1 (in group A) could cause for the user to select an option 2B, 3B, etc. from option group B, and then based on what is selected in group B, could determine the need to select an [employee name' from a drop-down combo box, and then filter based on the calendar control, before pressing the "generate report" button.
 

Multiple Selections in an Option Group

Multiple Selections in an Option Group Icon
Is it possible to create an Option Group (or some other type of control) where the user can select more than one option? I know I can make each selection a separate check box or radio button which would make multiple selections possible,
 

Option Group Query

Option Group Query Icon
For my latest conundrum, I am trying to construct a query that utilizes an option group selection for its criteria.

So, on a form for entering new equipment into the inventory database, a user utilizes the option group to indicate who owns the piece of equipment.

When the query executes, the column governed by the option group simply returns a number, which I assume to be the ID key for the option selected. I would like to have it return the plaintext name of the division associated with that number.
 

Setting Properties for Multiple Objects in a Collection or Array Simultaneously

Setting Properties for Multiple Objects in a Collection or Array Simultaneously Icon
I have a form which includes an option group and multiple controls that I would like to hide if a user selects a certain option in the option group.

The option box is called fmeKnitWovenOther. There is a label called fmeKnitWovenOtherLbl that I would like to hide when any option is selected and a number of controls I would like to hide only if the user selects option 2.
[code]
The problem is that I have set the .visible property of every control individually, but I will need to expand this form and add more controls to be hidden for the other two options. If I keep setting the .visible property for every control manually, I am going to wind up with a giant list of controls all manually set to .visible = True and .visible = False depending on theIf or ElseIf condition.
 

Forms Option Group

Forms Option Group Icon
I have created a Option Group in a form. The form is linked to a query but I would like the users selection of the Option Group to update a table.
 

Option Group and Radio buttons

Option Group and Radio buttons Icon
I added an option group and gave it to Label Names from the Option Group Wizard. It names the Frame105 and Radio Buttons Option89 and Option 91

I can't figure out how to test to see which one is selected.
 

Option Group and tab order

Option Group and tab order Icon
I have inherited an Access db which is primarily an input form. There are a lot of check boxes, set into option groups, so that onlyone check box can be selected in any group.

The users are asking that the tab order be changed, and I can not figure out how to make it tab into an option group, and then tab through the check boxes in the group.
 

set quantity of records based on option group selection

set quantity of records based on option group selection Icon
If option = 1 you can only add 1 record to frmPackage and 1 record to sfrmPart.

If option = 2 you can only add 1 record to frmPackage but you must add at least 2 records to sfrmPart.

If option = 3 you can add unlimited records to both.

The user selects the option.

frmOrder opens frmOP

frmOP has the option group control

frmOP opens frmPackage

frmPackage has subform sfrmPart