On Current Events

[Guest]

I Just attached my access front end to a mysql backend and the on current
events seem to mess things up. When I set a value through the on current
event it gives me the write conflict error that says "this record has been
changed by another user since you started editing it. If you save the record,
you will overwrite the changes the other user made. Copying the changes to
the clipboard ..."

an example of the code that is causing this error is:
Me.RemainingTime = Me.Startdate - DCount(...)

All of this code worked perfectly before I changed to the mysql backend and
from what I can tell it is just the on current events that are messing things
up.

 

[Allen Browne]

Dirtying the record as soon as you move to it is always a bad idea.

If this only needs to occur for a new record, use Form_BeforeInsert.

If it needs to occur for all records, use Form_BeforeUpdate.