OPTIONS BOX (uncheck)

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

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.
 
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.
 
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.

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