Expanding tables with calculating form fields?

Father · #12 11-29-2016, 08:34 PM

So I abandoned any further attempt to use the displayed output in any calculations.

For Table 9a.
The displayed output shows a number in the same cell as the dropdown. I type that number into the ITEM N.E.W. field.
The TOTAL N.E.W. field calculates the total (=UXOQTY1 * UXONEW1). This seems to be working.

For Table 9b.
The displayed output shows a number in the same cell as the dropdown. I type that number into the ITEM N.E.W. field.
The TOTAL N.E.W. field calculates the total (=DEMOQTY1 * DEMONEW1). This seems to be working.

Each ITEM N.E.W. text field has a run on exit macro which is supposed to give the option to add another table row.

Both are standalone tables with no merged cells, so I used the =SUM(ABOVE) to add up the numbers in the cells above it. That seems to be working as long as I don't use merged cells. If I do, it throws everything off.

For the table below those two (TOTAL NET EXPLOSIVE WEIGHT CONSUMED) I used the bookmarks for the previous totals to get a "grand total". That isn't working. I would simply add all of the formulas from the individual cells, but that wouldn't work if the ADD ROW option worked unless I added more formulas than I expected to ever need.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to keep formatted form fields after mail merge or replace text with formatted form fields	jer85	Word VBA	2	04-05-2015 10:00 PM
Tables with form fields	step10	Word	18	11-12-2013 02:27 PM
Enable editing in expanding fields	marweste	Word	11	10-21-2013 07:41 AM
How to prevent Tables from expanding	HappyFingers	Word	1	11-29-2010 01:54 PM
Calculating Form Fields in Microsoft Word	wubba80	Word	1	06-25-2010 12:42 AM