ADP Write Conflict

[Lynn_AccessUser]

I am using Access 2000 and SQL 2000. I am creating an adp.

I have a form (frmMain) with a subform (frm_sbf). On the subform the user can open another form (frm_popup) to update additional information on a particular record.

The problem occurs when I close frm_popup and then try to move to the next record on frmMain or move to the next record in the subform itself.

I get a Write Conflict msgbox saying "This record has been changed by another user since you started editing it . . . " with 3 buttons: Save Record, Copy to Clipboard, Drop Changes.

I have the unique table and resync command set on the subform.

Thanks for the help!

 

[Lynn_AccessUser]

Here is the answer:

http://support.microsoft.com/default.aspx?kbid=304181