[AccessD] Write Conflict

Hi Rocky,

Try something like this:

I'm going to guess that the tables themselves are linked with PK-FK same as
the forms?

1) On the subform after the quantity is updated add a line of code:
SubForm.Dirty = False.  This forces data from the subform down to the tables
immediately.
2) Main.Refresh on the main form to get data from the table immediately.
Recalculate the quantity in the main form if needed, and perform
MainForm.Dirty = False.  

Using the Form.Dirty method will clear pending changes and might help with
the conflict.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, April 02, 2014 9:43 AM
To: 'Access Developers discussion and problem solving'; 'Off Topic'
Subject: [AccessD] Write Conflict

Dear List(s):
 
I have a form with a subform - both bound - to different tables -
parent/child - linked Main form PK to subform FK - standard stuff.
 
When I change the quantity of one of the fields of the subform, a quantity
field on the parent form gets updated. All looks good until I try to move
the main form to a new record.  Then I get the Write Conflict message - Save
Record, Copy to Clipboard, Drop Changes.  I can see that if I Drop Changes,
the quantity field on the Main form reverts to its original value.  If I
click Save Record, all is well.  But I need for that message to go away.
 
How to I work around this message?  
 
MTIA
 
Rocky
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com