Duplicating records from a form with multi tiered subforms

[jonathanchye]

Hi,

I can duplicate a form with a single tiered subform but if my subform have their own subforms I am having issues finding a way to do this. I am using Allen Brownes example but I wonder if anyone can advise?

Below is a picture of my table relationship :



Uploaded with ImageShack.us

 

[Megan]

*Disclaimer: Listen to my fledgling ideas at your own peril and amusement. Sometimes I get it right, maybe you'll get lucky.

Append queries?