Dan Waters
dwaters at usinternet.com
Sat Aug 23 10:12:56 CDT 2008
If you check the table data before and after the code is run you'll see if it actually worked. In my first example, I assumed that you're trying to save a modified record on your third form and that the third form is not a subform. If it is a subform, then I would use: Forms.frmThirdFormParent.subformControlName.frmThirdForm.Dirty = False Which is what Shamil also described! Dan -----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 9:39 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Well, I'm trying to use that trick but that doesn't update the record, does it? Or does 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 Dan Waters Sent: Saturday, August 23, 2008 7:32 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Hi Rocky, How about: Forms.frmThirdForm.Dirty = False Dan -----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 9:15 AM 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