I have set up four option boxes with radio buttons to enter in a series of 4 values. I have also written a script for those numeric values to enter in the appropriate text into the database table:
Private Sub optwnvres_AfterUpdate()
Select Case Me.optwnvres.Value
Case 1
Me.[WNV results].Value = "Negative"
Case 2
Me.[WNV results].Value = "Positive"
Case 3
Me.[WNV results].Value = "Suspect"
Case 4
Me.[WNV results].Value = "No Test"
End Select
End Sub
The label "optwnvres" is the name of the option group and label "WNV results" is the name of the database field. I have also set the default value of the option group to "Negative."
I'm having trouble with the display of the option buttons as you can see from the images, each time I select an option the button greys-out. If I select an option from another group, all options on the previous option group grey-out.