Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Sat Aug 23 11:59:24 CDT 2008
Yes, and additionally another trick (used starting MS Access 2.0 as the latter didn't have .Dirty property), which could be useful if your subform has just one record - your can .Requery it to save current edits. If your subform has several records this trick will also work but then you will have to set the proper subform's record position - here .RecordsetClone and .Bookmark were usually used... == 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