Hi Rain this is not the latest version however this is a working version for the question at hand.
Attachment 4762
So far I have not been able to integrate this with my current forms successfully and although I may be on the verge of working this out, this is probably still quicker
If you open frmInsepctions2 you will see that the second subform(3rd deep) only populates the values after the form is clicked on or a control in the form is tabbed to/ clicked on. It would be great if this happened automatically as per question
Thanks