InfoPath Dev

Hoping you can help me out a little bit more - I've used the example file and altered it as necessary to utilise in my form.  It's all been done in notepad and the formatting is identical to the example you sent me but when I'm trying to add the .xml file as a data source I keep getting the below error message ...

Then instead of using rules for your submit options, set rules on the DDL. One action you can chose is to submit a form. Again, you can use conditions here -- if 'a', then submit using one data connection, if 'b', use another.

 Yes. So what if I want the form to be submitted as soon as the user selects the DDL. Thank you for  all your help.

I would use rules for my submit. I'd set the rules with conditions -- so, for example, if the DDL value was 'A', you'd use one submit connection to submit the form and if the DDL value was 'B', you'd use another. Make sense?

I was thinking of a custom submit button with rules.   Maybe using a custom dropdown list with rules. Any help will do. Thanks.

Thanks Hilary, I really appreciate the help.  I'll be recreating the form library soon and will modify the template with your suggestion.  Of course, I'll let you know how I get on. Thanks,   Paul

The rules are applied to the data source that is populated from an MS Access query into repeating table 1. There are no conditions set and the action is:      Set a field's value: Item_Description = @Item_Name where Item_Description is the from repeating table 2 and @Item is from repeating table ...

That makes it less straightforward, then, and you'll probably need code. I've not written anything to export to Excel -- hopefully someone else on the forum has and can contribute some knowledge on that. I did find a blog post with a sample for using managed code to submit data to an Access DB that may be of some help: ...

I need my InfoPath form to submit to a SharePoint library AND send an email to an approval group. This has to be repeated several times, as one group approves the form (on the form itself), then submits it to the next approver. However, I need the form to be updated on the SharePoint library as well with the approval info, so anyone can view ...

Yay, it works!  Thanks so much Hilary - I knew it would be something simple and had tried pasting in notepad but not saved it with the .xml extension :)