Difference between form close and application close???

[INeedAccessHelp]

Hi

I have a form that will delete the current record if the user closes the form by clicking on the "x" button in the upper right corner. I do this so that the user must click a command button in order to submit the information to the dbase.

Well, this upper right corner has 2 "x" buttons. When the bottom (form) "x" is clicked, the application does what it's supposed to and runs the On_Close event of the form which deletes the record from the dbase. When the user clicks the top (application) "x" button, the data is submitted to the dbase even though it the record is incomplete.

Any ideas on why it does this and what solutions you may have. Thanks.

 

[Rolliee]

send code to rollie@bwsys.net if you wish me to look at it.

Rollie E

 

[Steve101]

I think you'll find that if you set the Popup and the Modal properties of your form to 'Yes', then the top 'x' will be de-activated. You will be forced to close the form first, before the top 'x' (which is the close button for the application) becomes available again.

Having said that, I think that it is a problem with access that it does not seem to follow the expected chain of events when an application is closed. We had a long thread going, related to this a short time ago; let me know if you're interested, and I'll dig up the number.
Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[INeedAccessHelp]

Thanks Steve! If it's not much of an inconveniece, then sure I'd like that string.

 

[Steve101]

Here's the thread. Hope you get something out of it:

thread702-301158

Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au