InfoPath “Error Processing Form” error

Kept getting  this error last week after an InfoPath form had been updated. This happened every time I tried  to open up (create) the published form from the form library.  In Design mode I looked through all the fields and controls again, assuming I’ve made a mistake, but no mistakes were made.

There was however, something that was staring me in the face, which I hadn’t realised. I had actually changed a “Pull-Down Menu” control to a “Free-Text Box” control within the form. Initially, the pull-down menu control was set to use lookup values that were stored on a SharePoint list, and a data connection was configured for this.

Now that the control is free-text, there was no reason for the lookup values to be reference in the form. I removed the particular data connection, and republished the form, needles to say no more annoying Form Processing errors. Lesson learnt? Always check for stray connections, controls, reference etc etc…

Microsoft Gold Certified Partner

Connected Systems is now officially a Certified Microsoft Gold Partner. We’re a Microsoft house specialising in SharePoint products and technologies.

We have a team of extremely skilled individuals that enjoy what they do, and also meet the skills competencies required by Microsoft. We also have numerous case studies that goes deep into the solutions we have implemented succesfully. Definitely positive step forward, glad to be part of it all.

Auto-numbering within an InfoPath repeating table.

It’s quite easy setting up a column within an InfoPath repeating table to auto-number. Please see the list of steps to get this done listed below:

1) Double-click the intended column to get into it’s properties.

2) On the Data tab, under Default Value click on the fx (formula) button.

3) Within the Insert Formula box type this in Count(../preceding-sibling::*) + 1

4)  Click OK twice, and you’re done.

5) The above formula starts with 1. If for example 10 is used, then the numbering starts from 10.

Hope this helps.