Write Conflict error (Access 2007)

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.
 
J

Jeanette Cunningham

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO C# add in Outlook.Appointment error 0
Write Conflict 8
Write Conflict 3
write conflict 2
Autonumber field in Excel that behaves the same as Access 0
looking for a way around a write conflict... 2
Write Conflict Error 2
How do I set focus (and select text) on a text box on a modeless userform? 0

Top