I have been able to achieve my goals with my form but have one last issue. I would like to be able to concatenate the information of my report. I am not a programmer. My understanding is that I would need to create loop within loop with the concat function in the calculate event to achieve my goal. I tried with not much success. It is definitely above my skill level. Below is the hierarchy for my form. The blue square represent the information that I would like to concatenate and the orange square identify the repeating sub forms. If someone can assist I would much appreciate.
There is a bit more. I was only hoping to get a snippet and hopefully be able to extrapolate what I needed for the remaining of the form. I am fully open to sending you the form for you to work with if you wish. Do you have an email address for me to forward it to.
If the image you have provided above with the highlighted subforms are the only ones which are with multiple instances I can give you a snippet code which might work, otherwise I could have a look at your form and do it for you if you'd like.