Form Close

[WSF]

Access97
I have unbound forms that have rules applied to various controls in them.
The rules are applied as the form is being completed, rather than leaving
validation until the form is completely populated.
I would like to be able to close the forms using a CloseButton (maybe with a
confirmation msgbox) without invoking a rule (say OnExit) that may apply if
the user is part way through the form and has a control with the focus that
requires to meet a rule on exit of that control.
Is it possible.
TIA

WSF

 

[Allen Browne]

Just press the Esc key to undo any changes before clicking the Close button.

You must to it that way if you don't want Access to process the events.

BTW, use the BeforeUpdate (or AfterUpdate) of the control to validate it,
rather than the Exit or LostFocus event. This avoids the events firing when
there was no change (as is the case after you undo).