Results 1 to 2 of 2
  1. #1
    Jen0dorf is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453

    save form and subform

    Hi



    Have a form with a subform that is editable

    when I make a change and close the form only the changes in the main form are saved.

    So used the following code via a button in the header of the main form

    Code:
    Private Sub SaveChanges_Click()
    DoCmd.Save acForm, "frm_ErrorCorrection"
    DoCmd.Save acForm, "tbDetailsubform"
    End Sub
    
    
    tbDetailsubform
    However it does not seem to work

    Is my code wrong

    thanks

    Ian

  2. #2
    SuperAccessNinjas is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    8
    Is the issue that changes to the records in the subform are not being captured? Or is it that the design of the subform is not being updated?

    Need a little more info, but typically the data updates should be captured on close assuming a valid relationship between the Parent form and its Child subform.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 15
    Last Post: 01-28-2014, 12:20 PM
  2. Replies: 1
    Last Post: 02-21-2013, 12:27 PM
  3. Replies: 5
    Last Post: 12-19-2012, 01:05 PM
  4. Replies: 11
    Last Post: 11-10-2012, 03:00 AM
  5. Replies: 2
    Last Post: 01-29-2010, 11:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums