Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Location
    District Of Columbia, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    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?

  3. #3
    New Lounger
    Join Date
    Dec 2003
    Location
    District Of Columbia, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  4. #4
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    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.

  5. #5
    New Lounger
    Join Date
    Dec 2003
    Location
    District Of Columbia, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •