Using the Option Group Control

Learn how to Use the Option Group Control in MS-Access Forms. (video tutorial)
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,

Sponsored Links:

Related Topics

No way to tab stop on option button within group?
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,


Displaying a option group value in a report as name
I have a option group that represents the stages of a project. The option group is in Form1 and the value of the option group is in Table


Using an Option Group to Filter a Microsoft Access Form
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
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
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 Values Not Stored in Table After Selection
Im an Access novice and Im regularly reminded when the seemingly simplest of things fail to work properly. This is probably something terribly simple, but for some reason an option group value on one of my forms is not stored in the table once the selection is made. The control source appears to be selected correctly. I used the wizard to specify that the value should be stored in the table. Any ideas why my table does not update? I have some programming on the same form that is inserting values directly into the table once a surveyor inputs certain information. I suppose I could do this for the option group as well, but I'm a bit annoyed (at myself) that I cannot get this simple control to behave as intended. Anyone know what I'm doing wrong?


Option Group Reference In VBA
I have an option group on my form comprised of eight check boxes. How do I refer to the individual check boxes of the group in VBA?

The option group frame is frame27, the first buttons name is check30.

Lastly, to indicate check30s state when checked do I use true/false or the option value in its property sheet


Option Group Query
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
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.


Option Control to hide/show page tabs
I am creating a form where I have an option group with 7 options and a tab control with 7 pages. What I want to happen is when a user selects an option only the corresponding page tab is displayed, all the others are hidden. I would also want all the tabs hidden when opening a new record and no selection has yet been made.


Forms Option Group
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
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 Control to hide/show page tabs
I am fairly new to access databases and am teaching myself as I go along. However I have now got myself stuck!

I am creating a form where I have an option group with 7 options and a tab control with 7 pages. What I want to happen is when a user selects an option only the corresponding page tab is displayed, all the others are hidden.

I would also want the tabs hidden when opening a new record and no selection has yet been made.


How to display option group check box in subforms
I am facing following problem in MS Access sub form.Plz help me urgently.
I just want to display option group check box in sub form(eg option group have following values a)cell nbr b)home nbr c) primary nbr.

I just want that in each row user have option to select anyone values from option group.At present When I display option group and run form that only one value display but I want 3 check box on each row.


Option Group
Is there a way to filter specific data by my option group? So here is what I am doing. I have ages of people I want split out by.

<18

. I have created my option group with those 3 values. How can I tie this to the query I am running to filter it when I select one of those values


set quantity of records based on option group selection
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


option group default values
I have set up an option group to display a text value on the database table; however, I still need to click onto the default value for it to be entered. Can I set the option group to automatically select the default value


Option Groups
On my form/table I have a status field. I dont want to have this as a drop down so I decieded to use an Option Group.
I added an Option Group to my form
Added the desired values
Pointed it to the Status Field (on the form)

When I choose different radion buttons from the option group the status textbox changes accordinly.everything is great.
BUT
The radio button does not highlight or show active.

I tried to set the specific radion button Option to true but I get an error


Option Group and tab order
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.


Recordset selected by IF statement
Can I open the recordset using an IF statement?

For example, if radio button #1 is selected use Set rst = CurrentDb.OpenRecordset("qryMyTasksCurrUser") else use Set rst = CurrentDb.OpenRecordset("qryMyTasksAllUsers").

If yes, to the above question, how do I reference the option group and the choice made? Do I refer to the Option Group or the Option Button?

Do I have to do something to let the Option Group know which button is chosen?

Essentially, my goal is to create a recordset based on the choice (only 2 choices) in the option group.

I am new to option groups and haven't seen much in my limited research so I have no idea how to work with them.