Paul     Thank you so much.  I have learn so much from this.  The code is work great.  Now I just need to figure out how top do a grand total field.  Thanks again you're great.

Paul Disreguard the last email. Sorry Date: Wed, 16 Sep 2009 11:29:08 -0600From: forums@adobe.comTo: hwood71@hotmail.comSubject: Field CalculationsWhat error ......I modified your original form and reattached it here with the code in it. Paul>

Paul Didn't get an attachment. Did you get my attachment? I sent a word Doc with the error. Date: Wed, 16 Sep 2009 11:29:08 -0600From: forums@adobe.comTo: hwood71@hotmail.comSubject: Field CalculationsWhat error ......I modified your original form and reattached it here with the code in it. P...

Paul That didn't work and now it woun't open the file. it gives this error. I click ok and it closes and does nothing else. Date: Wed, 16 Sep 2009 08:58:47 -0600From: forums@adobe.comTo: hwood71@hotmail.comSubject: Field CalculationsClick on the field that will have the code on it (the Total...

Paul Excuse my novice, but where would I put the formula? The binding tab, field tab or value tab? I had the formula correct, but have no idea where it goes. Please let me know and thanks for the help. Date: Wed, 16 Sep 2009 07:43:28 -0600From: forums@adobe.comTo: hwood71@hotmail.comSubject: ...