Cannot Edit form and save to table

[shylock]

I have a form to track down time for our servers. I display the downtime table in a continuous form. I need to be able to adjust the downtime that was originally entered for a server to reflect the actual time that the server was out of service, if it differs from the originally requested length of time. When I edit the fields for date and time and then click the Save button I receive the following error: "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." It then gives me a choice of copying to the clipboard or dropping the changes.

There are no other users, as this project is in the test mode and the database is local to my PC>



My question is: How can I over come this error?

[Micron]

This can be caused by
- a bit field that has no data in one or more records (in tables such as sql server)
- code that doesn't save the current record but attempts to move to a different (or new record) improperly
- code that saves OK but then runs an update and doesn't save that update (or vice versa)
Probably there are other reasons not coming to mind at the moment. Might have to paste your save button code, and maybe form code related to field events.

Edit
- two subforms, one with update not saved & attempting to update the other.

[fletcjas]

It will be that your table has a 'NULL' where the field is set to 'Allow zero length = no'