Unable to edit form data

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
 
J

Jeanette Cunningham

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
 

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

Newbie Form Assistance - Unable to Edit 5
Addnew followed by Edit 2
Error to re-edit the record 1
How can I edit data on a form w/query w/ one-to-many relationship? 2
Form Values cannot be edited 1
Edit table entry in form view 5
Using Combobox to navigate form 2
Cant edit Access 2003 form 3

Top