How do I clear a checkbox group?

[Iram]

Hello.
I am using using access 2003.

I have a checkbox group however I would like to have the ability to clear it
without having to go into the table to delete the 1 or 2 that it puts in it.
Most of the fields are Yes or No checkbox groups but sometimes we
accidentally click one or the other when they don't apply. The undo button is
good however it is only good if the change was recent. How do you recommend I
do this? Please be very descriptive since I am not that great at this stuff!


Thanks.
Iram/mcp

 

[fredg]

Hello.
I am using using access 2003.

I have a checkbox group however I would like to have the ability to clear it
without having to go into the table to delete the 1 or 2 that it puts in it.
Most of the fields are Yes or No checkbox groups but sometimes we
accidentally click one or the other when they don't apply. The undo button is
good however it is only good if the change was recent. How do you recommend I
do this? Please be very descriptive since I am not that great at this stuff!

Thanks.
Iram/mcp

This is called an Option Group (not a Checkbox group), and you are
using a check box to select the appropriate values.
Add a third check box to the group. If the current check values are 1
and 2, then set this third check box value to 3.
Set it's label caption to "Clear"
Code the OptionGroup's AfterUpdate event:
If Me.OptionGroupName = 3 Then
Me.OptionGroupName = Null
End If

 

[Iram]

Your the man.

thanks.
Iram/mcp

This is called an Option Group (not a Checkbox group), and you are
using a check box to select the appropriate values.
Add a third check box to the group. If the current check values are 1
and 2, then set this third check box value to 3.
Set it's label caption to "Clear"
Code the OptionGroup's AfterUpdate event:
If Me.OptionGroupName = 3 Then
Me.OptionGroupName = Null
End If