Select a radio button in Options Frame based on combo box selection

[jrobin9151]

ACCESS 2003, Installed on a Network. I know this is probably easy to do can't remember it though. I have a combo box with several selections in the dropdown. Further down the form I have an Options group with four radio buttons that I've assigned the numerical value 1-4. When a user selects "Retired" in the combobox of a new record I want value #4 to be the selection in the options frame group of radio buttons. If the user changes to any other selection in the combobox then the options frame group would change back to null or no selection. I know it can be done in VBA but is there an easier way?

 

[MajP]

if the option buttons are inside an option group frame then

Private Sub myCombo_AfterUpdate()
If myCombo = "retired" Then
Me.myOptionframe = 4
Else
Me.myOptionframe = Null
End If
End Sub

 

[jrobin9151]

MajP
Thanks for helping me kick the rust off the pipes. It's been a long while since I've built anything in Access and it
all came back to me. Changed the coding slightly(see below) the radio buttons became a shaded grey when retirment wasn't chosen making it confusing looking. Forcing the value to 0 looks better and I'm thinking will work better with my query later. Thanks again for everything


Private Sub G_L_INT_AfterUpdate()
If Me.G_L_INT = "Retirement" Then
Me.Frame33 = 4
Else
Me.Frame33.Value = 0
End If

End Sub

 

[MajP]

Yes Null is grey, false (0) is empty.