Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Write Confllict Dialog

Status
Not open for further replies.
Jun 10, 2011
17
US
I have a main form with 2 sub-forms A & B
Both sub-forms display the contents of the same row in the same table juts with different layouts
SubFormA shows fields 1-5 while SubFormB shows fields 6-10
Data in B is updated manually and automatically based on inputs in A.

The problem occurs when the record is saved. Because the subforms share hidden linking fields when I save one; the other sees it as a write conflict even though the conflict value will be the same.
I get the Write Conflict dialog box with Save, Copy to Clipboard or Dump. If I don't select any options and just close the dialog box then all saves just fine.

How do I keep the write conflict dialog box from even displaying?
 
I appear to have resolved this issue. Before the Save command add line "On Error Resume Next"

'Save Record
On Error Resume Next
DoCmd.RunCommand acCmdSave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top