OPTIONS BOX (uncheck)

[Guest]

I have created numerical Options Boxes. RIght now, if I check in one of the
boxes, I can't "uncheck" the box. I don't know what else to do besides go
back into the Table to delete the data. Does anyone have any suggestions?
(the only thing I know that seems similar is checking/unchecking a Yes/No
field, but this isn't what I want. Thanks.

 

[fredg]

I have created numerical Options Boxes. RIght now, if I check in one of the
boxes, I can't "uncheck" the box. I don't know what else to do besides go
back into the Table to delete the data. Does anyone have any suggestions?
(the only thing I know that seems similar is checking/unchecking a Yes/No
field, but this isn't what I want. Thanks.

Do you mean an Option Group, where you wish to clear the entry
completely?
Add another button to the group.
Code the Option Group AfterUpdate event:

If Me![OptionName] = x then
Me![OptionName] = Null
End If

Where x is the value of the newly added button.

 

[Guest]

Thanks fredg, but I'm not really good w/ the coding. I usually use the drop
down menus and wizards. I don't really want to add another button, I just
want to be able to "uncheck" a button in case I accidentally click on it.

Thanks again.

I have created numerical Options Boxes. RIght now, if I check in one of the
boxes, I can't "uncheck" the box. I don't know what else to do besides go
back into the Table to delete the data. Does anyone have any suggestions?
(the only thing I know that seems similar is checking/unchecking a Yes/No
field, but this isn't what I want. Thanks.

Do you mean an Option Group, where you wish to clear the entry
completely?
Add another button to the group.
Code the Option Group AfterUpdate event:

If Me![OptionName] = x then
Me![OptionName] = Null
End If

Where x is the value of the newly added button.