Update or cancel update without addnew or edit error -2147352567

[Robin]

Hi,

When i update a record via a form and then use a combo to select another
record i get the following error:

Update or cancel update without addnew or edit - error -2147352567

I found one other thread with the same issue and it recommended the
following code in the 'on change' section of the combo

If me.dirty then
me.dirty = false

I tried this but it didn't solve the problem. I also found the following
explanation in access:

"Update or CancelUpdate without AddNew or Edit. (Error 3020)
On a Microsoft Jet database, you called the Update or CancelUpdate method
but did not use the AddNew or Edit method before writing data to a record.
On an ODBCDirect database, this error occurs when you attempt to write data
to a record without first calling AddNew or Edit"

Can anyone please tell me what i should do to fix this bug?

Many thanx
Robin

 

[Robin]

Some additional info - I have a lastmodified stamp on the form and some code
attached to the before update section. I removed this and the problem below
dissappeared...!!!

The plot thickens

Any ideas/comments will be appreciated.

Robin