Run-Time Error 3188

[hjeff71]

I have a Main form with a subform(datasheet view)

When dbl-clicking on any field of the subform, I open another form (frm_2) with all the details of the record clicked in the subform.

Private Sub contact_name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frm_2", , , "ID = " & Me.ID
End Sub

On frm_2, I have a “Save” button.

If Me.Dirty Then Me.Dirty = False

However, when clicked I get the message:

Run-Time Error 3188 "Couldn't update. Currently locked by another session on this machine"

I have checked the other thread about this error, but it doesn’t solve the error, can anyone provide some insight?

 

[namliam]

You cannot change the Dirty object's value... It is read only!

If you want to save you must save, saving will as a result set Dirty to false for you, no need to do that manually

 

[hjeff71]

Thanks for the info,

I have changed:

If Me.Dirty Then Me.Dirty = False

to

DoCmd.RunCommand acCmdSaveRecord

But i still get the same error message, any other ideas to explore?

(Forgot to mention, I am using Access2007 on Windows XP)

 

[namliam]

Perhaps the form isnt dirty?
I am at a loss for now... Plus I dont have 07 ...