[AccessD] Another User Edited this Record (XP)

Yikes, making a subform might be  areally good idea or a tabbed form, but with the existing structure make sure that you have:

DoCmd.RunCommand acCmdSaveRecord

when you open the second form (right before the DOcmd.OpenForm line) and when you close the second form have the same thing.  Additionally make sure you open Form #2 in teh acDialog mode so the use is unable to go from Form 1 to 2 freely, make sure they open form 2, use it a close it.

-Chris Mackin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Nicholson,
Karen
Sent: Wednesday, October 06, 2004 11:10 AM
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