Undo selection of check box

  • Thread starter Thread starter Lorenz Wild
  • Start date Start date
L

Lorenz Wild

Hi all!
today, this is my problem:

I have a checkbox that prompts a message box as an before
update Event. If the user selects "cancel" the check box
should be reset to its original value.

I've tried the checkbox.undo method but it does not work.
I've also tried to call the routine at various events
(afterupdate, beforeupdate, onmouseclick etc.)

The AfterChange-Method does not seem available for
checkboxes.

Any ideas? Many thanks,
Lorenz
 
Hi all!
today, this is my problem:

I have a checkbox that prompts a message box as an before
update Event. If the user selects "cancel" the check box
should be reset to its original value.
Click to expand...

Set it to its PreviousValue property in its own AfterUpdate event:

Me!checkbox = Me!checkbox.PreviousValue

A Checkbox doesn't have a Change event - which wouldn't be the right
event anyway; in a textbox it fires at *every keystroke*, i.e. every
time the content of the textbox changes. The AfterUpdate event fires
when a new value has been selected and updated to the table.
 
Back
Top