willjx
asked on
MS ACCESS: Want to get Option Group to stop always opening the last selected option 1st instead of the user selected option
I have an "Option Group", wizard created without a default selection, that has this unwanted quirk where it launches the pre-close, last selected option, instead of the user selected option, even though the user selected an alternative option. When the user exits the unwanted option, the user is then free to satisfactorily select the option(s) desired.
There are 7 options, each launching a 'built' macro that opens a specific Query.
There are 7 options, each launching a 'built' macro that opens a specific Query.
ASKER
I know not of what you speak.
I am aware of "the AfterUpdate event of the Option Group". However, I do not "code", and prefer not to code.
I am aware of "the AfterUpdate event of the Option Group". However, I do not "code", and prefer not to code.
The Wizard would have coded this for you. In the properties box for the Option Group, double-click the AfterUpdate event to open the code window.
OM Gang
OM Gang
ASKER
I "double-clicked the AfterUpdate event to open the code window", and all it did was toggle between Mprogram and EventProcdedure with no apparent Wizard coding.
Upload a sample database after removing all objects unrelated to this issue.
Explain what to do to demonstrate the problem.
Explain what to do to demonstrate the problem.
If you goal is to just launch a query when the user clicks one of the Radio buttons, then I'm not sure you need an Option Group for that. Option Groups are used for "One and Only One" type of selections. like Gender. Try removing the option buttons from the group (but leave the macros attached) and see if that solves your issue.
To remove them from the group, highlight the Radio button and it's label, and then press Ctrl-X. Then, click on the Detail section and press Ctrl-C.
To remove them from the group, highlight the Radio button and it's label, and then press Ctrl-X. Then, click on the Detail section and press Ctrl-C.
ASKER
Scott--Appears to be a better solution. I did your recommendation:
"..highlight the Radio button(s) and it's label(s), and then press Ctrl-X. Then, click on the Detail section and press Ctrl-V".
Properties auto-showed: "On Got Focus" with the correct embedded macro.
Clicking on the button evoked the appropriate macro/Query.
However, it will not allow me to close the Query, so I can select another button.
Clicking on the top right cnr, X or right-button clicking 'Close' does nothing.
What do I need to add?
"..highlight the Radio button(s) and it's label(s), and then press Ctrl-X. Then, click on the Detail section and press Ctrl-V".
Properties auto-showed: "On Got Focus" with the correct embedded macro.
Clicking on the button evoked the appropriate macro/Query.
However, it will not allow me to close the Query, so I can select another button.
Clicking on the top right cnr, X or right-button clicking 'Close' does nothing.
What do I need to add?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. Could not find anything wrong with the DB.
Took your suggestion to just use "Command" buttons in place of 'Options', and all is well
Took your suggestion to just use "Command" buttons in place of 'Options', and all is well
OM Gang