[AccessD] Update or CancelUpdate Without Addnew or Edit

Max Wanadoo max.wanadoo at gmail.com
Mon Sep 21 14:51:15 CDT 2009


If this has just happened on a form which hitherto was working ok, then do a
rebuild.  
If you have added any code to make changes to the data on the form (either
directly or via a Query) then put a me.dirty=false to ensure the change is
written away immediately.

Best of all, drop the multi-tab subform and replace with buttons.  Must
faster and easier to maintain.

Max


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

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




More information about the AccessD mailing list