View Single Post
 
Old 12-22-2016, 09:52 PM
Father Father is offline Windows 7 32bit Office 2013
Novice
 
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