MarkH
lists at theopg.com
Wed Oct 6 17:18:34 CDT 2004
You could unbind the second form and store its values hidden on the first form. When you open the second form read the values in from the first and when you close the second write them back (to the first form). That way the record is only bound edited and updated in the first form so no write conflick... Hth mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: 06 October 2004 18:10 To: accessd at databaseadvisors.com Subject: [AccessD] Another User Edited this Record (XP) Trickery needed. I have a form based on the table tblTrackingSheetWIP. Due to questionable database design, this form opens up another form, where the tasknumber=tasknumber, that is based off of the same table. User makes changes to second form. Closes second form and returns to route form. Tries to change data on the original form and gets the Another User Has Edited this Record.... Save your changes, etc. I have tried everything to get this record to save - closing the original form, DoCmd.RunCommand acCmdSaveRecord, refresh, the works. For now, I am closing the first form after I open the second, and it looks like I will have to just return to a prior form and make the user reselect the record to open up the first form. Any ideas on a workaround so I can open the first form gracefully? Am I making sense? Karen Nicholson National Laboratory Xerox Global Services -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004