MSAccess 2010 Subform, navigation will not leave the newly added row.

[Tobor]

Created an mdb way back in Office 2003. Upgraded it to MSAccess 2010.
Working fine.

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,
etc.

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?

Thanks.

[ruirib]

Probably the navigation issue results from the other issue - no additions allowed. I guess the answer to the latter is hard to provide without knowing the query it is based on and maybe even the form / subform involved.

Did you recreate the table relationships from the original table, if any?

[Tobor]

Everything was imported from original mdb into new mdb. All relationships are present.

If the query was the problem, then why are there no issues in the older mdb? In the older mdb the subform new row adds fine and allows navigation.

[ruirib]

I can't really answer that. Obviously something is not working and I don't have a ready answer, so I always start from the beginning.

[Tobor]

Additional information. The query used by the Subform is updatable. When I open, aka run, the query I am able to update and add new rows.

Something is causing a problem in the subform. Unable to modify existing data or add new rows. Checking the subform properties. Data Entry: No; Allow Additions: Yes; Allow Deletions: Yes; Allow Edits: Yes; Cycle: All Records; Record Locks: No Locks.

Deleting an existing row does work.

When I modify or add a new row and attempt to leave the row, expecting the changes/new row commit, I see at the bottom of the form "calculating...", but then the cursor has not moved from the row. When I click the "X" to close the form MS Access indicates it cannot save the data. However, if I modify an existing row, reopen the form and go back to the row I attempted to modify, the data is changed as I changed it.

What settings in MS Access 2010 are causing these problems?