Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    New York

    Question Unanswered: Appending A Form and it multiple subforms

    I have a form (frmOptions) with multiple sfrmPart attached to it. I need to append the not just the record in frmOption to tblOptions but also the multiple corresponding records of sfrmPart to tblPart with the new OptionsID.

    My code is not very good and I would really appreciate any help anyone can give me.

    Terri Gavin

  2. #2
    Join Date
    Oct 2004
    Melbourne, Australia
    You could add a function to be called in the AfterInsert event in the main form. This function would generate an INSERT statement entering the data into tblPart. This statement would be executed by a DoCmd.RunSQL statement. This is a bit clunky and generic and there are ways to make the subform respond to an insert in the main form, provided that your Option ID was part of the Master/Child relationship. However, I have always found the latter methodology to be very sensitive to the surrounding circumstances and hence difficult to debug and not very reliable.

Posting Permissions

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