InfoPath Dev

 See if this helps:  http://www.joellipman.com/articles/microsoft/sharepoint/519-sort-order-a-dropdown-list-in-ms-infopath-without-programming.html  Good luck.

 I don't know if this will help but my unique filename looks like this: concat("MyForm", SomeField, max(@ID[. > 0]) + 1)

 Here's what I have in the view1.xsl file.  I am not sure where to edit.  My guess is <xsl:if test="not(my:Fddl[.=$val] or $val='')">   <select style="WIDTH: 310px" class="xdComboBox xdBehavior_Select" title="" size="1" xd:xctname="dropdown" ...

 Excellent!  I will give this a go and let you know how it works out.  Thanks very much for the response.

I found some code to help me fill a drop down list that is listed here.   It works fine.  However, I need the drop down list to display a friendly choice while the back-end should pass a number value.  I don't know where to enter this.  Can anybody help by looking at this code?  I fill a repeating control and then I ...

 There's an idea.  Thanks.  I appreciate the response. 

Thanks very much for the reply.  I did try this originally and the form filled out prior does update in that the new field is there although it is not active. That said, it may be because I am testing too loosely. I will try this again after I modify the form template naming convention. I just noticed that my version is actually not ...

Scenario: I create a simple InfoPath form with 2 text boxes.  I publish the browser enabled form to a SharePoint library.  12 people fill this form in over a period of time (one year let's say). Next year, I have a new field that needs to be filled out for legal purposes or something.  Now, this field may not appear on the form ...

I figured this out.  IsDBNull seems to take care of it.  I ran thru the code in debug to check where the ordinal sat. It was 14 in this case. int EmailID = rdr.GetOrdinal("EmailID"); Then when using GetString: if (!(rdr.IsDBNull(14))) {      ...

I have my new form working great except today I ran into an issue with null values.  I thought I was capturing the nulls, but I was wrong. rdr is my SqlDataReader if (rdr[EmailID] != null)                         ...