I 've been getting "write conflict" error when I write between the main form
and the subform eventhough both forms have different recordsource. I read
that you can change the record-locking optins int the Advanced page of the
Options dialog in Tools a Options in Access to fix the problem. But it
doesn't say what the settings should be. Does anyone have knowledge on

Is there a way to trap or overwrite Write Conflict window from popping up?
Can someone explain what cause this error.

Thank you.