Option Group Radio Button Default is Null on Table

[sainttomn]

Hello all, I have a question that I assume has a relatively simple fix.



I have a form and an Option Group field called ZeroOption with 2 radio buttons, labelled Yes(=1) and No(=2).

When I open the form, submit the record, or clear the form, the Option Group resets to No (which is also the default in Properties), using the following code:

Me.ZeroOption = "2"

Visually, this works great, and the "No" radio button defaults as intended. The table this writes too, however, results in a blank field. If the user clicks the "No" option, this will sumit to the table properly. It seems like my code is missing something.

Any healp is greatly appreciated.

-Tomn

[RuralGuy]

Have you tried: Me.ZeroOption = 2 ??? It is probably a numeric field.

[sainttomn]

I just changed the code to Me.ZeroOption = 2 and got the same result.

The field on the table that this submits to is a Text Field. Perhaps I missed something in my earlier post as well. I use the code below to do a few things as well. Basically, besides changing the BackColor and BackStyle of a few labels this should set the Automatic Zero field (also on form and table -Text Field) to read Yes or No respectively.

Private Sub ZeroOption_AfterUpdate()
Select Case ZeroOption.Value
Case 1
[Automatic Zero].Value = "Yes"
Label276.BackStyle = 1
Label276.BackColor = 3937500
Label278.BackStyle = 0
Case 2
[Automatic Zero].Value = "No"
Label276.BackStyle = 0
Label278.BackStyle = 1
Label278.BackColor = 3329330
End Select
End Sub

When I click the radio button this works flawlessly, but the default code from my first post doesn't seem to select the radio button as much as rest the default there.

Thank you for your help,
-Tomn

[RuralGuy]

Would just setting the default value in the table work for you?

[sainttomn]

It absolutely would. Occam's Razor wins again.

Thank you very much for your assistance.

[RuralGuy]

I love those simple solutions!

[sainttomn]

Agreed! Thanks again.