Unable to edit form data

  • Thread starter Thread starter bigbear
  • Start date Start date
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
 
Hi bigbear,
finding a record is often best done using the recordset clone like this:

With Me.RecordsetClone
.FindFirst "File = " & ID
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With


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