Option Group Deselect

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Add a command button beside the group that sets its value to Null.

Private Sub cmdResetOptGrp_Click()
Me.[MyOptionGroup] = Null
End Sub
 
Thanks, Allen!

Allen Browne said:
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.

JohnLute said:
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!
Click to expand...
Click to expand...
 
Back
Top