InfoPath Dev

I am having trouble with auto-populating fields in a table using rules. My secondary data connections are two resource files. One has the categories for my drop down box, the other has the data I need to auto-populate in the table. Everything works fine except for one field. It will populate if it is the first entry in the table, but will not ...

You were right. I fixed it and it works. Now if I can just get my other problem solved. Thanks for the help. Todd Grayson US Army quote:Originally posted by Greg Collins Perhaps the rule isn't actually working... will you try putting an alert box at the end of your rule set to see if it reaches that? Greg Collins [InfoPath MVP]

I have a rule that sets a formula field to zero if it contains NaN. This field is dependant on tow other formula fields that are dependant upon fields that are autopopulated when the user selects from the drop down box. Everything works great when I preview the form, but when I actually go to fill out the form the field has NaN in it instead of ...

I finally finished my form and published it to a shared folder out on the network. When I run the form to test it, I get two ADO Security Warning messages. One says ''Website uses data provider that may be unsafe''. The other says ''Website is using your identity to access a data source''. If I click Ok, My form opens for input. What is ...

I got it working. I just needed to convert the string value to a double value. Thanks for the help. Todd Grayson US Army quote:Originally posted by crashoverride Does the data need to be converted to a different form before multiplying? ex: CInt(data)*num

The result is stored as double. The funny thing is that two of the three number work. Only the last one gets the error. I thought that it might be reading in the null character at the end of the string, but I am not sure. Todd Grayson US Army quote:Originally posted by crashoverride Does the data need to be converted to a different form ...

Ok, I got your code working, but now I have a different problem. One of the auto-populated values gets a NaN error when I try to do a simple multiplication formula. The other auto-populated numbers multiply just fine. Any ideas? Todd Grayson US Army quote:Originally posted by crashoverride I think I may have figured out a solution to the ...

I am also having the same problem as your first problem. Hopefully we can get an answer soon from one of the MVP's. Todd Grayson US Army