Write Conflict error (Access 2007)

  • Thread starter Thread starter LA Lawyer
  • Start date Start date
L

LA Lawyer

I sometimes have 2 forms open on the same record since there is not enough
room on the "main" form to put all of the data.

This causes Access to report a Write Conflict error.

I was told to include the following:

If Form.Dirty = True Then
Form.Dirty = False
End If

I wasn't sure which event was needed to insure that this was fixed, so I am
having it triggered by "on lost focus", which I assumed would be fine.

The error is still there. Is the code correct? Do I need it triggered by
some other event?

Thanks.
 
Hi LA Lawyer
Put it on the click event for the button that opens the other form.

Alternatively use a tab control on one form instead of using 2 forms.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top