Update or cancelUpdate without Addnew or edit error message

[Laudan]

I have a subform which has a macro which updates another field on the form
with a calculated value from the subform qry. I am getting an intermittent
error usually if data is corrected as it is being input of "Update or
cancelUpdate without Addnew or edit error" The macro is a set value followed
by a refresh. The error occurs sometimes after data entry in the CostPrice
control which contains the set value macro but can also occur in either of
the two following entry controles. The database is Access 97 on an NT4 Server
and we have other local versions in Access 2003 being used. The data tables
are held in another database and are linked. To make matters worse, at one
point I got a 3020 error message a power failure was detected. I have removed
the set value macro but the same problem occurred so it appears not to be
that. Any help gratefully recieved! Thanks

 

[Tom Wickerath]

Hi Laudan,

There seems to be lots of hits when searching Google Advanced Groups for the
error message. A common theme seems to be the need to save a record before
doing something that can programmatically move to another record. For
example, see the answer that Allen Browne provided in August, 2001 for
helping to resolve this error message:

http://groups.google.com/group/micr..._frm/thread/1516d4d7ff794c3e/99728399b7b6602c

Here is a link with all of the hits I found (happy fishing!):
http://tinyurl.com/brsw4

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a subform which has a macro which updates another field on the form
with a calculated value from the subform qry. I am getting an intermittent
error usually if data is corrected as it is being input of "Update or
cancelUpdate without Addnew or edit error" The macro is a set value followed
by a refresh. The error occurs sometimes after data entry in the CostPrice
control which contains the set value macro but can also occur in either of
the two following entry controles. The database is Access 97 on an NT4 Server
and we have other local versions in Access 2003 being used. The data tables
are held in another database and are linked. To make matters worse, at one
point I got a 3020 error message a power failure was detected. I have removed
the set value macro but the same problem occurred so it appears not to be
that. Any help gratefully recieved! Thanks