How to stop a Option Group Value from changing?

[BRV]

I'm adding a "user confirmation" to respond to changing an option group value by clicking the appropriate toggle button.

I have code in place to check if the form is "dirty" and pop up a confirmation dialog if it is. It works beautifully.

The problem is that if I place the code in the option group's BeforeUpdate sub and use Cancel=True, it doesn't stop the fact that the value has already been changed.



If I use .Undo, it undoes the other data that was entered (that I'd like to keep).

I'm not sure where else to go from here. Any suggestions?

[RuralGuy]

Try Me.ControlName.UnDo instead.
...using *your* ControlName of course.

[BRV]

Thanks, RuralGuy.

I tried that, but unfortunately, it didn't work. Not sure why. It seems like it should...

I finally brokedown and assigned the value to a variable to hold it in memory and reassigned it back to the control to undo the change. There should be a better way, but I guess it works, so at least I can move on.

[RuralGuy]

Whatever works for you.