Good day everyone,
I have the following error:
On "Debug" it stops on following line of code: (Me.Dirty = False)
Please note that code ran fine before with no issues. Not sure what changed. Form is based on a query which does not have a "new record" option. (as in, cannot insert a new record in query) I tried changing it from Dynaset to inconsistent updates. Now the query does have an option to insert new information, but I still get the same error.
Any ideas what could be wrong from that code above?
I have the following error:
Run-time error '3027' Cannot update. Database or object are read only.
when using a certain form.On "Debug" it stops on following line of code: (Me.Dirty = False)
Code:
Private Sub findWI()
With Me.RecordsetClone
If Not IsNull(lstWI.Value) Then
If Me.Dirty Then
Me.Dirty = False
End If
.FindFirst "[Work Instructions].[ID] = " & lstWI.Column(0) & ""
If Not .NoMatch Then
Me.Bookmark = .Bookmark
lstWI.Value = ID
End If
End If
End With
End Sub
Please note that code ran fine before with no issues. Not sure what changed. Form is based on a query which does not have a "new record" option. (as in, cannot insert a new record in query) I tried changing it from Dynaset to inconsistent updates. Now the query does have an option to insert new information, but I still get the same error.
Any ideas what could be wrong from that code above?