B
bigbear
I have a form with lots of data drawn from a complex query which links
6 tables. (Access 2007, Vista). It has been working fine for a year.
Over the past few days I made some minor change and upgrades and now
the form cannot be edited. The query remains fully able to be edited
and hasn't been changed at all.
More precisely, when the form opens it is possible to edit records. If
I move to other records with the record navigation arrows editing
remains possible. However if I move to a specific record using the
following code the form can no longer be edited and the message 'This
recordset is not updatelable' appears in the status bar.
Public Sub OpenGoTo(ID)
Me.Recordset.FindFirst "File = " & ID
End Sub
It is really very strange. Any ideas gratefully received!
Thanks
Bear
6 tables. (Access 2007, Vista). It has been working fine for a year.
Over the past few days I made some minor change and upgrades and now
the form cannot be edited. The query remains fully able to be edited
and hasn't been changed at all.
More precisely, when the form opens it is possible to edit records. If
I move to other records with the record navigation arrows editing
remains possible. However if I move to a specific record using the
following code the form can no longer be edited and the message 'This
recordset is not updatelable' appears in the status bar.
Public Sub OpenGoTo(ID)
Me.Recordset.FindFirst "File = " & ID
End Sub
It is really very strange. Any ideas gratefully received!
Thanks
Bear