[AccessD] Update or CancelUpdate Without Addnew or Edit

You can determine that with 

If me.dirty then
	Me.dirty = false
End if

That will write away and updates pending for the current form.


Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: 21 September 2009 20:59
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit

I have had the same problem with Access 2003/Access 2007.  It is my
impression that the order of events for subforms in Access 2007 is subtly
different than 2003.  But I can't prove it and the problem is generally
intermittent and not reproducible.  I've also corresponded with a couple of
other programmers with the same thing.

The only workaround I've found is to rewrite the logic of the update so that
you absolutely know that there is a record available to be updated.

Doug

On Mon, Sep 21, 2009 at 12:02 PM, Rocky Smolin
<rockysmolin at bchacc.com>wrote:

> Dear List:
>
> I have a rather complex form with a multi-page tab.  Some of the tabs have
> subforms
>
> When I open the form and click in an empty space on the subform I get the
> message "Update or CancelUpdate Without Addnew or Edit".  If I go to any
> other tab page with a subform and click anywhere on the subform I get the
> message.  One of the tab pages generates the message without even
clicking.
>
>
> I can click on any tab page which does not have a subform with no problem.
>
> I get this problem in 2007 but not 2003.  My client has it in 2007 and
> 2003.
> But not on all machines.
>
> I'm stumped.  Any ideas welcome.
>
>
>
> MTIA
>
> Rocky
>
>
> --
> 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