InfoPath Dev

This all sounds super weird. Including the Word doc screenshots. I am glad you have a workaround, but this just doesn't sound right. I guess if I were to try anything, based on the workaround you found, I'd right click the Matter dropdown in designer, and under the properties, find the browser tab. Set it to always postback and see if that ...

I think it is under Form Options > Preview.

I actually just tried this in a form - and my calc'd default value came back as 0 when the fields that made up the calculation were blank - which caused me to remember the setting in the attached screenshot. Does changing that for your form make a difference?

You have all office updates / windows updates installed? Since this is SharePoint Online, you may need to open a ticket with Microsoft.

So - you are trying to update the existing XML file? What is the form name set to that a new item is being created instead of the original file overwritten? I assume you mean the user is opening an existing XML and then clicking a button in that form?

So, for me at least, when I run into formatting not behaving the way I expect, most often it is because the value of something isn't what I think it is....can you share your form? Just attach the template under the options tab in a reply...

Yick. I just tried from my SharePoint Online site and was able to customize in InfoPath... Have you tried doing this the opposite direction? Open InfoPath Designer, select SharePoint List template and enter the list URL? I assume this is happening with more than one list? If you create a new test list, can you customize that in InfoPath?

So - I don't understand why the MileageRate1 field, which is a true / false field, is being used in the repeating table... shouldn't the mileage rate in the repeating table (the calculated value) be bound to a number field? The field called "MileageRate" which I was guessing would be the actual rate, looks like it is a choice ...

Try this one. You don't need to query the list again - you are doing that when the form opens. I've got rules on MileageRate1 to set MileageRate - hopefully that is what you needed.

Unfortunately, there is no straightforward way to do this - and since your form is bound to a DB, I think there is no non-code way to do this. If it was not a DB bound form, you could add rows by default to the table and use formulas to populate them, hiding the blanks. But I don't think you can do that in a DB form.