How do I clear a checkbox group?

  • Thread starter Thread starter Iram
  • Start date Start date
I

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
 
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
Click to expand...

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
 
Your the man.

thanks.
Iram/mcp




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