Rocky Smolin
rockysmolin at bchacc.com
Mon Sep 21 17:44:53 CDT 2009
Me.Refresh seemed to work on my Vista/07 machine. I could not reproduce the error on my XP/03 machine although the client could. So I sent it off to him for testing. That's really where it has to work. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, September 21, 2009 1:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit Try opening it normally and see if the error is still there. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 21 September 2009 21:05 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit Because the form opens slowly, I open it when launching the app and invisiblize it until needed. I put a Me.Refresh into the Activate event and will send for testing. Me.Dirty = False would probably do the same thing? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, September 21, 2009 12:51 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com