Made Field Null if Invisible, Can't Change Value When Made Visible

[470vinyl]

I have an option button "BTNPercent" that when enabled, "BoxPercent" is visible with a default value of 30. This works for the first time I hit "BTNPercent"



When I uncheck it, "BoxPercent" becomes invisible, and the value becomes "null". When it is brought back via "BoxPercent" being enabled, the value is still "null" despite my code to change it. See below. Optnewrev is set to 1(confirmed many times via breakpoint)

Private Sub BTNPercent_AfterUpdate()

Select Case Me.BTNPercent.Value
Case Is = true
Me.BoxPercent.Visible = True
IIf optnewrev.Value = 1, Me.BoxPercent.Value = 30, Me.BoxPercent.Visible = True


Case Else


Me.BoxPercent.Visible = False
Me.BoxPercent.Value = null


End Select


End Sub

[Micron]

Not sure of some things. One thing that would help would be consistent and correct terminology. When in use, option buttons aren't really "enabled". They're selected - or not. More importantly, their value is passed to the frame that contains them, and that value is the "Option Value" property. This may be your biggest issue: if the options were correctly attached to a frame, you get the value from the frame, not the buttons. Then there is "uncheck" as you put it. Check boxes are "checked" and those are a different animal as you probably know.
EDIT
Also, when you post code, please use code tags (# on toolbar) with indentation in the code (makes it easier to read and avoids things that the forum sometimes does to code not contained in code tags), but mostly, try to be accurate with the pasted code. What you have posted surely must present an error message (the IIF part)