The script needed for each total field calculation.The only thing different between them is the "6" is changed for each category (i.e. personal leave is "0"). Select FormCalc in script editor. This definitely works in your form--guaranteed!.    var oDays    = _IndvSubForm.count    var totHrs    = 0 ...

Looks like there are 2 subForms that have hours that need to go into the total (Consecutive and Individual)--unless you are only doing one of those.When you add a day, what subform(s) get added? The IndvSubForm? or ConsecSubForm? or both?If both, wrap those 2 Subforms in another Subform and have tha...

Gabriel,Please open your Hiearchy Pallet and click all the + so everything is visible. Try to expose as much as you can--open it wider if it helps. Then take a screen shot of it and post it here.Stephen

Hi,The script can't find the subform--probably the name is wrong. Maybe use: LeaveCatSubForm[i-1].DataDropDownList2  There are various ways to determine the correct SOM reference. At the top of the script editor (look in the image you posted at the top) you'll see the SOM fof the object you are edit...

Hi Gabriel,#1 in the "for" loop, you should be referencing [i] not [*]#2 I made a mistake, it should be IndvSubForm[i-1] in the loop (not [i]) since the first subform is IndvSubForm[0]  //my bad//////////////////////////////////////////////////////////////////////////////////////////////////////////...

Hi,I am assuming that the the AddDay button adds an instance of a subForm--lets call that subFormDay, OK?I am also assuming that your dropDownCategory has some sort of paired value in the Binding Tab of the Object Pallet--lets say they are numbered like  PLD is "1"MilitaryLeave is "2"Leave w/o Pay i...

Hi Niall,Feeling especially lazy today, I thought I'd try asking rather than testing this to find the answer. How does updating scripts in the library work? If I have multiple forms that use a script from the Fragment Library, when I tweak the script and save it, does the tweak change the script in ...

Hi,Go to File>Form Properties>SecuritySelect the password option and when you save the form you'll be given opportunity to set 2 fifferent types of access passwords (open, edit)Good luck,Stephen

I am marking this as answered--I need to make changes and put in front of the user that has problems. This may take a day or two to have the user to test it. I really appreciate your help radzmar. I will re-post this problem if it remains unresolved after testing.Stephen

Hi radzmar,Thank you! very much for your suggestion. I'd like to understand your solution a little better:the TableHORates has 14 columns (Cell) containing other rate and features information for each of the products--this script only uses the 1st 5 cells. So, I think for c=0 upto Cells -1 step 1 do...