Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2016, 09:52 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



Quote:
Originally Posted by macropod View Post
Had you simply copied tables 9a & 9b, plus the updated code from the document in my last attachment (or if you'd stuck with that document and changed whatever other details might need changing), everything would have worked fine. Part of the editing I did entailed renaming some of the formfields & calculation fields so they would work properly with what you're trying to do.

As for the 'other' option, that is necessarily the last row because of the way the coding works. And, once you reach the limit of 25 entries in the dropdown, the 'other' option disappears - since it would no longer be valid. It might be advisable to tell your users that, if they're likely to need multiple rows with 'other' options, they add the necessary rows before choosing 'other'. That way, subsequent rows won't be pre-populated with the results of 'other' options from previous rows.
I'll give that a shot. Thanks.
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 02:15 AM.


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