Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sat Aug 23 13:12:23 CDT 2008
Cool. Thank you. 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 Shamil Salakhetdinov Sent: Saturday, August 23, 2008 9:49 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Yes, Rocky, that's a trick, which I used a lot in the past since MS Access 97 AFAIKR... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, August 23, 2008 7:28 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Shamil: So setting .Dirty = False saves the record? TIA 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 Shamil Salakhetdinov Sent: Saturday, August 23, 2008 7:38 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Hi Rocky, AFAIKR you can just use: Access.Application.Forms.mySecondFormName.mySubFormControlName.Form.Dirty = False or if you have an object reference (let's call it subFormControlObjectRef) of the second form's subform control then you can use: subFormControlObjectRef.Form.Dirty = False -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, August 23, 2008 6:15 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Forcing Save from on one form from another form Dear List: In a sub-form of a second form I am changing the value of a record on a third form which is loaded and open. That form is now dirty and I'd like to save the record on that third form from the sub-form. How can I force a save on one form from another form? 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