Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


MS Access Run-time error 3020 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.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums