Radio button loses focus

[Guest]

I have an option group (with 2 radio buttons) on a data entry form. When the
form opens, the first radio button in this option group has focus and is
selected. All well and good. When I select an option from a list box on
that form, the radio button loses focus and I'm not able to select either
radio button. It's as if they are non functional.

What happened and why and how to fix it?
Tia,

 

[Ken Snell [MVP]]

Sounds as if some code is running on an event related to the option group or
the option button or the list box, where the option group is being disabled
and/or locked.

 

[Guest]

Thanks for the reply.

After reading your post, I created a test table with 2 fields; ButtonAnswer
(type yes/no) and FieldText (text). I then created a new form with the
Option Group and 2 radio buttons (Yes & No). The Option Group was created
with the wizard where the selection is stored to a field (ButtonAnswer). The
form's data source is the table.

When the forms, the first radio button has focus and is selected. I can not
select the second radio button. In fact, when I try to select the No button,
it doesn't get selected and I can't select the Yes button again. When I open
the form again and begin typing in the text field, both radio buttons lose
focus and neither is selected.

I just now added a new Option Group where I chose to "Save the value for
later use" and not the "Store the Value in this field:" and it works like it
should. Weird.

Shouldn't I be able to store the button value in the field of choice?

btw, on the next subsequent record, the Option Group holds the previous
record's selection.

<still confused>
tia,
JMorrell

 

[Ken Snell [MVP]]

You should bind the option group frame control to the field, not the
individual option button itself. And yes, the option group should show the
value of the field in the record as you move from one record to another.

Are you using a query as the form's RecordSource? is that query updatable?
If not, then you won't be able to edit the data in the option group.

Also, is the form's AllowEdits property set to Yes? If not, you again will
not be able to edit the values in the option group when it's bound to a
field.
--

Ken Snell
<MS ACCESS MVP>

 

[Guest]

Thanks for the tips. I'll look into it.

JMorrell