I found Allen Browne's website where he describes how to copy a form's records and any records for related subforms. Now, I need to copy not only the form's and related subform's records but also the records of the subform of a subform. For instance, I have a form for a particular person. That form has a subform for the person's addresses. Then each of the addresses has another set of data associated with it in a sub-subform.
I need to find a clever append query that will copy the sub-subform's records.
Thanks for the help.