Runtime error 3020

[Guest]

Can someone please help me with this error message..

It says
"Runtime error 3020 update or cancel update without addnew or edit"

it occurs when trying to makes changes or edit a record.

I am using a database that someone else made for me so if you can please
explain in elementary terminiolgy.
Thank you very much

 

[Guest]

Well.. not to point out the obvious..

But it looks like you're trying to update without first doing an addnew or
edit to your recordset. Essentially you're telling Access to save changes..
but you never made any. I guess it gets grumpy when we make it waste it's
time..

Do you know which function/sub it's happening in?

 

[Guest]

Lance,
Yes I know it's obvious..and sounds like a dumb question but that is
exactley what is happening. I go to make a change in a record - sometimes it
works fine and otehr times it doesn't. I can not find a button / tab or
anything called "addnew or edit record"
Tha's what the frustration is all about.
Tahnk you very kindly for your time.

 

[Guest]

No, not a dumb question. Sorry if I made it seem that's what I meant. I've
experienced this thing plenty of times..

What I was trying to ask is if there was a VBA function that was being
called in the process that is crashing? And if in that function there is
something that looks like rst.update. If there is make sure that there is
something that looks like rst.addnew or rst.edit. Note: The "rst" could be
called anything, it's just the variable holding the recordset.

 

[Guest]

Thank you I will look into this and see if we can find this... to be
continued.
Thank you for your help.