Created an mdb way back in Office 2003. Upgraded it to MSAccess 2010.
For some reason had the idea to create a new mdb in MSAccess 2010 and import
the tables, queries, etc from the existing mdb. Did so without problems.
Notice in the new mdb when I add a new row on the subform, navigation will
not leave the newly added row. There is logic in the BeforeUpdate and
AfterUpdate events. These both successfully run. BeforeUpdate is not
canceling the event.
Finally, I click to close the subform and I'm told "You can't save this
record at this time, etc". If I click "Yes", then the new row I want to add
is not added.
I don't have this problem in the upgraded mdb (the original 2003 MSAccess
was upgraded to MSAccess 2010).
All required fields are present. The subform is set to allow updates, edits,
Any idea why the subform will not allow me to navigate to another row or
save the new row when a new row is entered?