InfoPath Dev

Hi Clay - you are right as i tried adding the same code to a click event and i got the following message through cirtix (but still works fine locally or when i access the form through server) The following error occurred: ActiveX component can't create object: 'Wscript.NetWork' File:script.vbs Line:28  

Thanks Clay - Wouldn't mind giving it a go with the web services. For some reason i beleive the form/script was working fine with cirtix - might try on click event and see if it could load the user name. Any other way you beleive is easier than the web services? Else happy to have your demo

I have a form that loads the username in one of textboxes - based on the user names it then queries the database to populate the values in a drop down. I use the following script in the onload event to get the username: Sub XDocument_OnLoad(eventObj) Set wscNet = CreateObject("WScript.Network") ...

Matt - All i'm saying is that i have tried working on the paper and individually with each field on the form to achieve the results. If the formula is verified why doesn't it work? Take your Form for example - you have tried to have one set of calculation on the first row of the repating table (field2 = x + 10). And from 2nd row onwards ...

Could anyone help and provide their expert advice?

Matt, Your form is 50% of what i'm looking for (i.e 1st row to have fdifferent calculation and 2nd row and onwards to have different calculations) - which is working fine. The other 50 % is that from second row and onwards the field should also use previous row's field value (preceding-sibling) for calculations. below if the ...

Thanks Matt - the form is simple and self explanatory but what i'm trying to do is the 2nd row show first column should have default total (from the other columns) + the value of the first column first row. The default value formula recognises preceding-sibling group but not the field. Would it be easier if i attached my form?

Matt - default value formula does not recognise preceding-sibling. How did you approachw ith yoru sample form and how did the amount field get populated - by inserting new row or upon filling out any field in the same row? if you could detail your steps may be it might help.......thanks again

Hi Matt, Thanks for the help - your calcs makes sense but do not work -  the formula is correct and verified (see below what am i using) but the amount field do not get populated by the formula. The way i apply the formula is on the Repeating Table by making a rule where the type (drop down) is equal to to 1 - expression used in the ...

I have form with repeating table (columns - Date, Amount, Type and Percent). Amount field is calculated based on the Type and Percent. So for each new row inserted after 1st row the new amount is amount (from previous row) * percent (from previous row) * value (depends on type - from previous row) ....... i have used preceding-sibling in my ...