InfoPath Dev

After I began applying the formula to my real form, I've run into a problem that doesn't make sense.  The same formula works just fine on one section of options, but applying it the exact same way on another section gives me different results.  I've re-done it several times and even ...

Yes!  This works!  Worked on a practice form and then on a form with more true to life (numerous) selections, so I am sure I can now apply it to the real form.  Thank you very very much! Nalani

The form opened fine in design mode, but refused to open in preview mode. It looks like InfoPath has a problem with using the [. = ''] filtering in an eval() expression for a default value with the Automatically Recalculate option selected. I've worked around this by having each of fields 1-5 set field6 to the value ...

Sorry, thought you wouldn't be able to open it either and it wouldn't do any good to forward.  Attached is one of the practice forms with the formula in it.  Thanks.

Well, you can attach it to the thread without re-opening it in InfoPath, right?

You're right that the form I attached didn't have the separator formula in it - it only has the original concat formula that doesn't include separators between the items.  I couldn't find a way to send the form with the separator formula because as soon as I save it, the form will not open again.  When attempting to open ...

I don't see that formula in the form you attached.  Did you attach the version of the form that doesn't have that formula in it?  And is InfoPath providing a Show Details button where you can see a more specific error message?

hi, i want to know how can i add new records to a sql database table that has a foreign key relationship with another table using infopath form. i have created a blank form based on database i have all my fields and the "add new" button already in the form. i have the username and the userid  and some other fields filled in ...

 I almost done my project, but when I try to publish it to SharePoint I got following error message " Preserve code blocks are not supported in web browser forms. To fix this problem, remove the code"  :( I am in trouble, any luck or alternate solution with this error message.

I have attached a practice form that has a small section of my very large form which has many similar sections except that there are many more options available for the user to choose from than the number I've carved out for this practice form.  When you check the box next to Environmental, some Submatter options will display and ...