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