I am having a few problems with an option group when I go to a new record. I am using the following code:
Private Sub Frame35_AfterUpdate()
Select Case Frame35.Value
Severity.Value = "Severe Harm (Red)"
Severity.Value = "Moderate Harm (Amber)"
Severity.Value = "Minor Harm (Green)"
It works great until I go to a new record. The radio button selected in the previous record is "greyed out" but it doesn't record the value in the control source, unless I click on another of the radio buttons and click back. The risk is that users may see the radio buttoned as "grey" and think it is already selected. I want to clear the option group so no radio button is "greyed" when the user goes to a new record.
I have looked through the forum but not found anything that can help.