[AccessD] Another User Edited this Record (XP)

I tried these scenarios.  This is so dicey that I spoke with my manager
yesterday and he has agreed that the fields on the second form should be
in their own table.  I have inherited a messy system, but my manager is
really smart and is starting to allow me to make structural changes when
warranted.  So today I shall restructure...

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, October 06, 2004 1:56 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Another User Edited this Record (XP)


Hi Karen

You need to requery form1 when form2 has created changes.

/gustav


> 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