Question

Locked

How come I get this error: Update or CancelUpdate without AddNew or Edit?

By jflec032 ·
Hi Folks,

I need a little help here. I'm kind of new to Access and stuck working with an old version (2002).

The database is set-up in a multi-user environment, where everyone has a front-end on their desktop and the back end is saved on a shared network. Every now and again, for what appears to be no rhyme or reason, people get the following error when trying to move to the next record: Run-time error 3020 Update or CancelUpdate without AddNew or Edit. The team can go days without anyone recieving the error, and then all of a sudden everyone on the team starts to experience it at the same time. Then it will stop and start up again.

According to the debugger, the error is being caused by something in this string of code:

Private Sub Combo329_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[CSGC Number] = '" & Me![Combo329] & "'"
If Not rs.NoMatch Then Me.Bookmark = rs.Bookmark
End Sub

Can anyone help me figure out what is going on here? When explaining please keep in mind that I'm kind of new to Access. Thanks a bunch! .

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums