Using the Option Group Control
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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,
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.
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.
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.
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.
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.
I can't figure out how to test to see which one is selected.
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.
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