Hi BruceBrilliant!  The only thing I dont understand is why do you not need to reference the instance manager in the change event of the AnythingToReport field?Thanks for all your great work and helping me out of a sticky problem.Darren

Hi My form is adding a subform at the bottom.  How do I get it to add the subform to the top.  It looks like I can use a moveInstance command but dont understand how it works.Any help greatly appreciated.ThanksDarren

Hi Bruce Many thanks for getting back to me.  The basic problem is that if possible I want the monthly activity subform hidden unless the anything to report drop down list is yes.  However when you click to add a new monthly activity it renders the hidden subform and I cannot work out how to add the...

Hi BruceI think Ive worked out that it is rendering the next subform as a hidden one.  Not sure how to fix that given your new code?ThanksDarren

Hi BruceThat is really great and works perfectly! Thanks so much for your help and your code looks so much simpler! Last question if thats okay. I have now set the monthlyactivity subform to hidden. I only want to display the Monthly activity subform when the anything to report field is set to y...

Hi BruceMany thanks for getting back to me so quickly. It is nearly working correctly but not quite.When you click on add next monthly report the validation is not working for the new report when you hit the add another activity button. However it does work on the initial report and this is what I...

Hi BruceThanks for getting back to me.  The link to the form is at the bottom.I have had a play around with it and made some progress.  I can now add the repeating subform within the repeating subform okay.  I have had to add a stop command at the end of my loop as otherwise it was adding double the...

Hi I am producing a form which I want to have repeating reports.  I have created a subform for the report which also contains a section (further subform) which can repeated in the report by clicking a button.  This works fineWhen I come to repeat the original report I cannot get the section to repea...