[AccessD] Close object without saving

What you need is 

Docmd.SetWarnings True

Which you can type in the immediate window and hit enter.

This setting is specific to each database, and it defaults to True (On).

Normally this code is used, for example, just before running an update
query, and then the warnings are turned back on with Docmd.SetWarnings True.


I suspect that you have turned warnings off at some point in your code and
then did not turn them back on. This setting persists with the database even
when it is closed and started up again.

A common cause of the problem is where warnings are turned off in code, but
then a runtime error happened and they were never turned back on. That is
why I always ensure that routines that turn off the warnings have an error
handler that turns them back on.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Thursday, June 09, 2005 11:27 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Close object without saving


No, I found that.
What I'm looking for is the dialog box and asks if I want to save the query,
form, etc. Instead it automatically saves. Thanks Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Randall R Anthony
Sent: Thursday, June 09, 2005 10:16 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Close object without saving

Is this what you're looking for?  Added to the end of the DoCmd. statement.

, acSaveNo
--
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