Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2016, 03:05 PM
Father Father is offline Expanding tables with calculating form fields? Windows 7 32bit Expanding tables with calculating form fields? Office 2013
Novice
Expanding tables with calculating form fields?
 
Join Date: Nov 2016
Posts: 29
Father is on a distinguished road
Default

Sweet. Thank you.
Before I dive into those links/tutorials...

I was using Legacy Forms controls.
I just replaced a lot of the drop downs and text fields with the current versions.
I didn't do that with the fields that have the calculations. I'm wondering, before I start messing with it any further, is there a way to have conditions so that if I select something from a drop-down menu, it'll populate other fields.

Here is the form I'm referring to
https://drive.google.com/open?id=0B9...zUtenBveEZoNE0
The form is protected but there's no password (just leave it blank).



Right now I have it set up where I put the numbers in manually and it calculates the totals.
What I'd like to do is be able to select something from the drop-downs under Nomenclature and have it populate the Item N.E.W. field with a number. Then when I put in QTY, it'll calculate the TOTAL N.E.W.
Is that possible? Or am I asking too much of Word and should be doing this in something more dynamic like Acrobat? I did try this once as an Adobe form, but there are other pages that have functions that I don't think Acrobat offers like inserting photos.

I'm assuming the expanding tables option isn't possible, but ideally, I'd only like to have rows when I need them and not have a bunch of empties (clutter).
Reply With Quote
  #2  
Old 11-18-2016, 07:53 PM
macropod's Avatar
macropod macropod is offline Expanding tables with calculating form fields? Windows 7 64bit Expanding tables with calculating form fields? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Father View Post
I'm wondering, before I start messing with it any further, is there a way to have conditions so that if I select something from a drop-down menu, it'll populate other fields.
See, for example:
https://www.msofficeforums.com/word/...html#post46429
https://www.msofficeforums.com/word/...html#post88302
https://www.msofficeforums.com/word/...html#post74823
You might also be interested in the formfield conditional formatting solution in:
https://www.msofficeforums.com/word-...html#post47254
Quote:
Originally Posted by Father View Post
I'm assuming the expanding tables option isn't possible, but ideally, I'd only like to have rows when I need them and not have a bunch of empties (clutter).
I've already provided you with a link for that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-19-2016, 02:08 AM
Father Father is offline Expanding tables with calculating form fields? Windows 7 32bit Expanding tables with calculating form fields? Office 2013
Novice
Expanding tables with calculating form fields?
 
Join Date: Nov 2016
Posts: 29
Father is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
See, for example:
You might also be interested in the formfield conditional formatting solution in:
...
I've already provided you with a link for that.
Sweet. I"ll be checking it out all. Thank you so much!!!
Reply With Quote
Reply

Tags
calculating values, expanding table, form fields



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
Expanding tables with calculating form fields? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft