Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Tue Jul 29 17:59:44 CDT 2008
Ooh. Tricky. I'll try it. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Tuesday, July 29, 2008 3:54 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Data Has Been Changed Rocky Try Form_Matters.MatterActionsSubform.Form.Dirty = False WBR ~ Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Tuesday, July 29, 2008 6:31 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Data Has Been Changed It gets a little more complicated here. The field I changed in Form A is also bound in Form B. So I need to save the record in form B from Form A. Don't know how to do that. DoCmd.RunCommand acSaveRecord only works for the form it's in. I suppose I could put the DoCmd into a module in Form B and call it from Form A. But that seems a little kludgey. I worked around it by doing a Requery from A to B but that's not a good solution. (I don't even know why it worked.) Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Tuesday, July 29, 2008 2:21 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Data Has Been Changed Rocky, Does saving (.Dirty = False) the record before updating work? WBR ~Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Tuesday, July 29, 2008 3:46 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Data Has Been Changed Dear List: I'm updating a field on different form that the one I'm on using: Forms!Matters!MatterActionsSubform!DueDate = Me.ActionDate and I get an error 7878 Data has been changed. If I debug and hit F5 it carries on OK and updates the field in the target form. But I can't find much about this 7878 or how to work around the problem. Does anyone have any experience with this error? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com