Prevent form close depending on close method

[lixolin]

I am well aware of how to cancel a form from closing (set 'cancel = true' in unload event) but i would like this prevention to be based on how the cancel event was started. i know i have seen code for this somewhere online while looking for something else but now i can't seem to find it. What i want is to prevent the closing of the form in all other ways but when i call it from code with docmd.close.

From what i remember about this is that you had some value that told you how the form close had been initiated (like 1 if it's called from close, 2 if its called by the system, 3 if you hit the clsoe button, etc etc)and that you could base your code on this. Does any one know what i'm talking of? I know i did try it when i found it the last time and I think it worked pretty well for the thing i need to use it for now!

All help and ideas appreciated!

[ItsMe]

I am not aware of this approach. I imagine it would be possible to use a Select Case statement to evaluate whether the intrinsic close button was clicked. I believe the conventional approach would be to evaluate the data in the form using "Before Update". In this case it would not matter how the form is closed and or you can use an If Then or Select Case to evaluate constraints and decide whether or not to call DoCmd.Close

90% of my forms have the "Close" button disabled.

[RuralGuy]

The easiest way is to define a global public variable in the code module and set it with code. If it is not set in the UnLoad event, then cancel the close.

[ItsMe]

I am curious how Access would know (or how you could remind Access) if the intrinsic close button for the form was clicked vs. another control.

[RuralGuy]

I am curious how Access would know (or how you could remind Access) if the intrinsic close button for the form was clicked vs. another control.

AFAIK it can't beyond the fact that only you know about the variable tested and only you can set it to bypass the cancel code.