You need to add a button (or similar) to the form that will set the OptionGroup value
to Null. The normal behavior is that once you make a selection you are stuck with at
least one option always being selected. I usually add a button or label that says
"Clear" and set the group to Null with that.
when i'm running code from the option group's OnClick or
AfterUpdate event, i usually capture the value in a
variable and then reset the value to null, as:
Private Sub OptionGroup_OnClick()
Dim intSelection As Integer
intSelection = Me!OptionGroup
Me!OptionGroup = Null
'whatever actions you want performed when
'the option group is clicked.
End Sub
end result: your code is carried out, AND the option
group's buttons are all "up" and ready to be selected
again.
hth
-----Original Message-----
You need to add a button (or similar) to the form that will set the OptionGroup value
to Null. The normal behavior is that once you make a
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
