Changes made in form are not save sporadically

[struggling]

Hi everybody,



I've recently been experiencing some strange behaviour when editing data in Access forms: Sometimes changes I have made to a record wouldn't save even after going to the next record. Let me explain how my forms look like: they typically consist of a main form containing several subforms. Normally when working on a record I begin editing data in the main form and then jump to one of the subforms. In most cases, I then go back to the main form and after that switch to the next record.

Now sporadically it happens that the changes I made to the main form "jump back" to their original values after leaving the subform, i.e. I add or modify an entry in the subform and as soon as I set the focus back on the main form I can see the values I had changed just a few seconds before virtually switching back to the values that the entry had before editing it at all. Since most of my fields in the main form are combos I have only observed this weird behaviour with combos.

Even after leaving the record and loading it again I won't be able to make cahnges to it. Only a restart of the complete Access application will enable me to modify the record. Oddly enough, changes I made to the subforms within the same record ARE saved.

This is really getting problem for me as I can never be sure whether it has saved the changes I made or not. What is even more confusing is that this behaviour seems to occur only sporadically with no obvious reason triggering this "mode".

Something that may be unrelated but also occurs sporadically is that it doesn't prompt to save changes I made to a form when closing it. On other occasions, though, it won't allow NOT saving a query even if want to close it without saving changes.

This is really confusing. Has anyone witnessed a similarly strange behaviour before? Is there maybe a known issue related to that?

Thank you in advance for your help!

[Freshman]

Sound really strange yes.
Was it always like this or did it only start recently?
Did you try the app on another machine?
Did you try to do a "Detect and Repair"?

[struggling]

Hi Freshman,

it's strange indeed.

As to your first question: It was like that from the start. Not permanently, but sporadically, as I wrote before, which means that there could be a week without any interferences at all and then another day it happen repatedly.

Of course I've tried it on other machines. The database in running a LAN with two clients accessing it. The strange behaviour occurs on both PCs. One of the two didn't have Windows Updates turned on, but this doesn't seem to make a difference.

I've run detect and repair several times, but in my view this only affects the tables, doesn't it? The thing is that the forms normally DO work as they should, so it's not that they have a basic design flaw.

Yesterday I read about forms that are partly not refreshing when moving to the next record. Could it be something like that? It appears to me that the changes are only visualised superficially, but are not saved then. Anyone thinking the same?