Prevent "Write Conflict" from appearing

[smercer]

Hi all

I have a form which has two subforms with the same record source (via different Queries), one of form view and the other in datasheet view (to make it like an index).

When I change a record in the datasheet subform it will change the same record, same field in the form view (which is what I want) but this "Write Conflict" dialog box appears and changes what I entered.

Is there a way to stop it from appearing or make it so that the choice is already made with coding?

Thanks in advance

 

[Marat]

http://www.accessvba.com/showthread.php?s=&postid=57342