You should get a good start here and the linked articles by Dian Chapman:
http://word.mvps.org/faqs/customizat...nTheBlanks.htm
The forms decribed in the article above are oddly called online forms.
Using on line forms, you don't need a macro. You can use Textfields to hold
your QTY, Unit Price, Decription, and a Calculation field for the total.
--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support
Mike Shimizu wrote:
Office XP
I believe it was office 97 that had a purchase order templat you could
download that had formulas to extend unit price and subtotal the
exteded prices for all line items and total at the bottom.
All the templates I have seen do not have this anymore, they appear
to be just empty table fields you type in. The specific template I
downloaded was PO w/ unit price.
How do I create the formulas to have my PO template, calcualate
automatically?
I have tried on line one of the PO where you input qty , unit,
description, unit price. In the total field, I tried Table-Formula.
Tried =product(A1,A4) , tried =product(A1:A4), tried =(a1*a4) none of
these worked.
Then I tried designating the qty field with a text form field and
formatting to numeric. Did this for all releveant fields with
bookmark names a1, a2, a3 , a4. Then tried all the variants of the
formula I mentioned above. Still nothing works.
I recall there was a macro that was needed for this to work back in
the Office 97 days. Which of course I do not have this macro or any
idea how to make it. Is this why it's not working for me now?
I do not see where my e-mail goes in this form so here it is:
mike.shimizu(remove