InfoPath Dev

What's the code you've tried?

I tried to use the code from this post:

http://www.infopathdev.com/blogs/jimmy/archive/2009/03/06/automatically-adding-rows-to-repeating-sections.aspx

On my form i set the Form Options > Programming > Code Language to: Visual Basic (InfoPath 2007 Compatable)

Then i went into the Button Properties > Edit Form Code > and paisted the Visual Basic 2007 example from the link above:

MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Test_Section",NamespaceManager).AppendChild(doc.DocumentElement.CreateNavigator());

Thanks again for your help.

I have been trying to find something that will work here...

I have this C# code:

XmlDocument doc = new XmlDocument();
            XmlNode newParent = doc.SelectSingleNode("Group2_1");
            XmlNode newScreenToSupport = newParent.Clone();
            newParent.ParentNode.AppendChild(newScreenToSupport);

and im getting this error when i click the button:

System.NullReferenceException
Object reference not set to an instance of an object.
   at programmatically_add_new_section.FormCode.CTRL18_5_Clicked(Object sender, ClickedEventArgs e)
   at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

I also tried:

}

Once again, thank you for any help

 Is your form a browser or filler form? If browser, ExecuteAction won't work for you.

 EDITED TO ADD - sorry, that didn't sound too helpful. But if ExecuteAction will work for you (your form will be a filler form) then it is going to be the simplest code - if not, I can help you with the code.

Thanks for the responce!

It is a browser form so that explains why that option is not working. Now, I made the form with the intention of using it in the browser but that is not a neccesity. I could switch the form over to a filler form if that makes it work.

 Any help is greatly appreciated.

 If you change the form compatibility to Filler (under the form options) the initial code you were trying would likely work for you - and that would be the simplest approach. :)

Well that sounds good. Is there anything i should lookout for when switching the compatability? any adverse effects?

 Not when going from Browser to Filler - Filler has more functionality than Browser. The other direction you can have issues - but the Design Checker will usually give you a head's up.

 Well, it worked until i unchecked: 'Allow users to insert and delete sections'

When i did that the XmlToEdit on the advanced tab goes away....

I need to uncheck the 'Allow users to...' because the point of the exercise is to stop users from being able to remove sections. 

Any advise on how i should proceed?

Thanks again. 

 okay - so you have to allow that in order for this technique to work - I'll grab your earlier form sample and help you with a little code.

 Okay - a few things I should mention - qRules can do this for you in a rules based way, as well as delete nodes and a kajillion other things - you can try a free download here.

However, given the sample form you first posted, you could add code to the button on the form, and use this:

   //get the parent node for the repeating group
   XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:A", NamespaceManager);

   //clone a node
   XPathNavigator child = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:A/my:Aa", NamespaceManager).Clone();

    //append the node
    parent.AppendChild(child);

This is C#, for IP 2007 or greater. The stuff in bold you can replace with the correct XPath to your parent (non repeating) group and your child (repeating group). This is not bullet proof by any means - if, for example, you set your form to not include the repeating group by default, this will fail. But hopefully it is simple and understandable and you'll be able to try it.

Fantastic! That worked.

I do really want to mess around with qRules. I have seen it as the answer to many problems on the forums but it is not a part of my budget. I will however download the free version to learn more about it for future projects.

Thank you for all of your help!!

In testing I realised that this will keep the data from the cloned node in the appended node. Is there any way to only clone the structure and not the data?

 Thanks again.

 You have two choices - you can clear each field or you can clone from the template's sample data. I usually just clone from sampledata - that way even if the group isn't included by default, I'll be able to clone:

            //get the parent node for the repeating group
            XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:A", NamespaceManager);

            //clone a node from sample data
            XmlDocument sampleData = new XmlDocument();
            sampleData.Load(this.Template.OpenFileFromPackage("sampledata.xml"));

            XPathNavigator child = sampleData.CreateNavigator().SelectSingleNode("/my:myFields/my:A/my:Aa", NamespaceManager).Clone();

            //append the node
            parent.AppendChild(child);