[AccessD] Form Closing Problem - New(?)

If I use DoCmd.Close acForm, FormName, then the problem doesn't appear.
Only when it's closed with the Access window's X button.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Friday, January 15, 2010 9:09 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Form Closing Problem - New(?)

Dan, I think you need...
 
DoCmd.Close acForm, FormName, acSaveNo

>>> On 1/15/2010 at 9:47 AM, in message
<1E1D20B6B8184B2A8328033C3D0A775B at danwaters>, "Dan Waters"
<dwaters at usinternet.com> wrote:
At only one customer, they are experiencing a problem when closing forms.  

For example, I can open a form in Form View add a new record.  If I then
close Access with the X button in the upper right corner of the Access
Window, Access now asks if they would like to save the changes to the form.
This happens with forms after the recordset has been modified.

If I close the form with a button that uses DoCmd.Close acForm, Me.Name,
then no problem.  If I leave the form open, then push a button on the main
screen to use Application.Quit, then no problem.  But if I've opened a form
in form view, changed the recordset, then close with the upper right X
button of the Access window, I get the question 'do I want to save changes'.

I've decompiled/compiled, compacted/repaired, and rebuilt the Access files
by importing all objects into a new Access .mdb file.  But that doesn't
help.

Has anyone seen this issue?  How did you solve it?

Thanks!
Dan




-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com ( http://www.databaseadvisors.com/
)
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com