[AccessD] Form Locked

...you may have to change the form to design mode first before you can close 
it that way
...since its modal, you may have to call its own close event from the parent

William

--------------------------------------------------
From: "Tony Septav" <iggy at nanaimo.ark.com>
Sent: Sunday, April 26, 2009 2:18 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Form Locked

> Hey William
> Thank you very much for your response.
> I entered DoCmd.Close ACForm, "Form1" in the OnUnload in the parent form
> and received an error message "Close Action cancelled".
>
>
>
> William Hindman wrote:
>
>>...in the parent OnUnload, can you check first to see if the modal form is
>>open ...and if it is, close it.
>>
>>William
>>
>>--------------------------------------------------
>>From: "Tony Septav" <iggy at nanaimo.ark.com>
>>Sent: Saturday, April 25, 2009 11:27 AM
>>To: "Access Developers discussion and problem solving"
>><accessd at databaseadvisors.com>
>>Subject: [AccessD] Form Locked
>>
>>
>>
>>>Hey All
>>>This has got me baffled and I figure there has to be an easy answer that
>>>I am missing.
>>>I have a program where I prevent the user from shutting down the program
>>>by closing the app. window. I use the On Unload to check to see if a
>>>variable has been set to true, if not all actions are cancelled and a
>>>MsgBox appears.  This works fine in most cases. On one form I have a
>>>button that pops up a modal form so that the user can enter in project
>>>notes. Now when the user tries to shut down the app. by clicking the
>>>close button a message appears and close is cancelled. The problem I am
>>>having is the notes form is then locked (basically everything is locked)
>>>and I have to use the Windows Task Master to close the program.  If I
>>>make the underlying form visible False (which I usually do and turn in
>>>back on On Close) no problem. I have tried a myriad of things API calls,
>>>other code etc. to no avail. Any suggestions????
>>>Thanks
>>>
>>>-- 
>>>AccessD mailing list
>>>AccessD at databaseadvisors.com
>>>http://databaseadvisors.com/mailman/listinfo/accessd
>>>Website: http://www.databaseadvisors.com
>>>
>>>
>>>
>>
>>
>>
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>