Option Group Deselect

[Guest]

I have a form with some option groups that have no default values and that
are not required.

For example, one group has 3 choices:
Single
Double
Triple

If I make a selection then it's recorded in the table. How can I deselect
from the form rather than going into the table?

Thanks!

 

[Allen Browne]

Add a command button beside the group that sets its value to Null.

Private Sub cmdResetOptGrp_Click()
Me.[MyOptionGroup] = Null
End Sub

 

[Guest]

Thanks, Allen!

Add a command button beside the group that sets its value to Null.

Private Sub cmdResetOptGrp_Click()
Me.[MyOptionGroup] = Null
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a form with some option groups that have no default values and that
are not required.

For example, one group has 3 choices:
Single
Double
Triple

If I make a selection then it's recorded in the table. How can I deselect
from the form rather than going into the table?

Thanks!