InfoPath Dev

Hello,

I have an Infopath form that stores data in text fields from an sql datasource.  All of the fields on the form can store data, but when I add any new fields, the field is there but I cannot enter data in the new fields.  Any suggestions as to how I can rectify this problem will be greatly appreciated.

Hey Joshua.

Is the SQL DC the main or a secondary?

Are the fields you mention added to the SQl table or into your form?

Is this new forms or existing forms that were completed before the change?

Give us some more detail.

Hi Clay,

The SQL DC is the main connection, and the fields are added to the SQL table and we are pulling them from the main data source onto the form. 

 This was an old form, and it had two stages.  Stage two needed additional fields, so we re-opened the form and first added the new fields from SQL and then dragged them onto the form.  When the form was published to a SharePoint library and then accessed, we were unable to enter data in the new field.  However, if we dragged an old field onto the form that was not used before, we were able to populate it with data.  Thanks for a quick response.  Any assistance appreciated.

One thing is that if you change the SQL Tables you need to go into Data Connections and modify the Data Connection and go through the setup again for it to see the new fields in the form.

Then you also need to set the update exisitng forms in form options.

In 2007 go to form options and then the versioning section and sekect to automatically upgrade exisitng forms. Otherwise the existing forms do not have the new fields in their schema.