Option Group (Yet Again)

[TeeSee]

Using Access 2003
First attemt at understanding option groups and have searched this
GROUP but can't seem to come up with an answer.

I have used the wizard to create a group of two option buttons Button1
and Button2. Behind each button I have very basic programming when
Button1 is true one text box is hidden and when Button2 is true a
second text box is hidden. The buttons function properly bu I believe
there are two issues.
1) Sometimes the small form would load with one or other of the text
boxes already hidden which meant that I'd have to manipulate the
buttons to get where I wanted. Solved that by adding code OnLoad both
text boxes visible.
2) Having done that, now when the form loads and everything is visible
the buttons are not in a ready state to make a single choice. One
button is true and the other false and I have again to activate the
buttons a couple of times to get the layout I want.

My access inside out text does not offer too much insight as to how to
program these buttons.

Any assistance would be appreciated. Thanks

 

[Arvin Meyer [MVP]]

Where is your code? In Design View, click on the Option Group frame itself,
not the option choices. You should have an [Event procedure] in one of its
events (probably Click or AfterUpdate) If you don't, that's probably your
problem.

 

[Ron2006]

In design mode:

1) select the Frame control for your set of buttons.
2) Right click and select "Properties"
3) Go to "Data" Tab
4) Change the default value to 0


Also wise to move 0 to the Framecontrolname in the onLoad event along
with the code you have to make the buttons visible.

Moving 0 to the framecontrolname is how to reset the selection to
"None of the above"

Ron

 

[TeeSee]

In design mode:

1) select the Frame control for your set of buttons.
2) Right click  and select "Properties"
3) Go to "Data" Tab
4) Change the default value to 0

Also wise to move 0 to the Framecontrolname in the onLoad event along
with the code you have to make the buttons visible.

Moving 0 to the framecontrolname is how to reset the selection to
"None of the above"

Ron

Thank you both very much ..... Arvin I have removed the code I had
behind the buttons and Ron the FrameControlName = 0 solved the other.
Again Thanks