Created options group with toggle buttons but can't find stored in

[Guest]

I have created an option group with 2 toggle buttons- Passing, Marginal and
Failing. They have the values of 1, 2 or 3. In a form, I am able to push the
button and have it remain down but cannot find where it stores the data. When
I built them another time, I had it chosen to store data in the Course status
field as Number. When told to store in that field, it doesn't allow me to
click on the button. What am I doing wrong?
Any suggestions?
Thanks in advance.

 

[ACG]

The value of the selected option is stored on the group
it's self. IE if the Group is called MyGroup and the
buttons Btn1=1, Btn2=2, Btn3=3 - if Btn1 is selected then
the value of MyGroup = 1

 

[John Vinson]

I have created an option group with 2 toggle buttons- Passing, Marginal and
Failing. They have the values of 1, 2 or 3. In a form, I am able to push the
button and have it remain down but cannot find where it stores the data.

It stores it in the table field specified in the Option Group's
Control Source property. If the option group has no control source, it
isn't stored anywhere.

When I built them another time, I had it chosen to store data in the Course status
field as Number. When told to store in that field, it doesn't allow me to
click on the button. What am I doing wrong?

How did you "tell" it? What's the Control Source property of the
option group control? If it's the name of a table field, what is the
datatype of that field? What's the Recordsource of the form?

John W. Vinson[MVP]

 

[Guest]

Ok- I have gone to the form and clicked on the outer box where the option
toggle buttons live. There was no control source listed so I changed the
control source to the Course status in the Gr 8 Student info table. Now the
toggle buttons do not work - they beep when pressed. Course status is a
Number field (to take the 1 2 or 3 of the toggle button value).
What am I doing wrong now?
Thanks for your help.