I have not been able to get it to work. First of all I do not have sub forms, just drop down fields and fill-in fields. The form the Magus069 sent me is very extensive for someone at my level of programming. I went through it and tried to create my own based on the script, but have not been successful at all.
I understand the above language and formulas, but unfortunately I do not have subforms. I have tried to manipulate the above script, but once again I am not having luck.
Thank you both very much for your input. If one of you is willing, I could send you the form and you could take a look and see what I have done (or not done) to have the results that I am getting.