How do I reset the Option Group back to Null after opening new form?

[DanicaDear]

I am using a set of options groups with some code that puts the text (rather than the typical 1,2,3, etc) into the table. I got the directions from this post:
http://bytes.com/topic/access/answer...oup-value-text

Here is MY code:

Private Sub FrameSeries1_AfterUpdate()
 
 Select Case Me![FrameSeries1]
    Case 1
      Me![txtSeries1] = "Odd"
    Case 2
      Me![txtSeries1] = "Even"
    Case 3
      Me![txtSeries1] = "All"
    End Select
  End Sub
 
Private Sub FrameSeries2_AfterUpdate()
 
 Select Case Me![FrameSeries2]
    Case 1
      Me![txtSeries2] = "Odd"
    Case 2
      Me![txtSeries2] = "Even"
    Case 3
      Me![txtSeries2] = "All"
 
  End Select
 
End Sub
 
Private Sub FrameSeries3_AfterUpdate()
 
 Select Case Me![FrameSeries3]
    Case 1
      Me![txtSeries3] = "Odd"
    Case 2
      Me![txtSeries3] = "Even"
    Case 3
      Me![txtSeries3] = "All"
 
  End Select
End Sub
 
Private Sub FrameSeries4_AfterUpdate()
 
 Select Case Me![FrameSeries4]
    Case 1
      Me![txtSeries4] = "Odd"
    Case 2
      Me![txtSeries4] = "Even"
    Case 3
      Me![txtSeries4] = "All"
 
  End Select
End Sub
 

However, when I open the form and select options on the first entry, those options follow me around (remained clicked) when I go to the next form (either already with data OR a new form).

To be clear, as I scroll through I would want the forms already filled out to remain with the options that were selected at their time of entry. I would want the options on new forms returned to null. I already have the default of both my options groups AND my text boxes (txtSeriesX) set to Null. This doesn't seem to work.

Can anyone offer any advice?

**Update: I wanted to report that I made my text boxes visible and the input data IS staying with the appropriate records. However when the database goes live the textboxes won't be visible (as this would confuse the user). So keeping the radio buttons to align with the text boxes that are storing the text value of the radio button would be helpful. And the problem of them not defaulting to Null on a new record still exists.

Thanks, Danica

[NeoPa]

Don't store the text value. Display it as text when you must, but always store the numeric value only.

If I understand you correctly (and I'm not positive I do) then that should resolve your problems.

[DanicaDear]

NeoPa, I took your advice here and stored the numeric value only. And it did solve my problem.

As you know, I scrounge around the web to find ways do all my "tricks" in Access. This has created a new question that I think is simple, but I have looked for 8 hours on the internet still with no solution. Time to "Ask a(nother) Question" on Bytes!! :-)
One day, I hope I Rest in Peace. hahaha

[NeoPa]

"One day, I hope I Rest in Peace. hahaha" - Danica.

I sincerely hope that day doesn't come too soon Danica. We'd all miss you.