Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2020, 04:21 PM
lburch lburch is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2016
Novice
Hide table based on dropdown list
 
Join Date: Jun 2020
Posts: 1
lburch is on a distinguished road
Default Hide table based on dropdown list

Hi,

I would like to have a dropdown list (currently using "legacy") and then based on that selection show 1 of three tables (i have three options in dropdown list)


Metal
Tile
Metal and Tile

I have tried inserting If statement with no luck. I even tried a test one
{ IF {Dropdown2} = "Metal" "Test" }

But i get
Error! Missing test condition.

I get the feeling i am not constructing IF statement correctly.
Reply With Quote
  #2  
Old 06-23-2020, 04:45 AM
macropod's Avatar
macropod macropod is offline Hide table based on dropdown list Windows 7 64bit Hide table based on dropdown list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You should use:
{IF{REF Dropdown2}= "Metal" "Test"}

Note: Both sets of field brace pairs (i.e. '{ }') for the above example are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. The spaces represented in the field constructions are all required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-12-2021, 12:39 PM
BT13 BT13 is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2010
Novice
 
Join Date: Mar 2021
Posts: 4
BT13 is on a distinguished road
Default

I am wanting to do something similar, except that based on the selection of the drop down, additional tables would pre-populate later in the document. I have used the If statement and am successful in getting the tables to pre-populate; but I am unable to edit them and the legacy forms within the table go away. Any suggestions?
Reply With Quote
  #4  
Old 03-12-2021, 01:59 PM
macropod's Avatar
macropod macropod is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

That is how documents employing formfields work. Other than the formfields themselves, you can't edit any portion of the document that has the formfields protection applied to it - and that includes formfields that you might embed in other fields.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-12-2021, 02:33 PM
BT13 BT13 is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2010
Novice
 
Join Date: Mar 2021
Posts: 4
BT13 is on a distinguished road
Default

Paul, you are just the one I was HOPING would answer! I have been spending days going through the forums reading your stuff and trying to figure out how to use your guidance to do what I need. I was just reading your response (https://www.msofficeforums.com/word-...tml#post118315) Trying to figure out if that is what I am needing. Can you confirm that your answer in that thread is along what I am looking to do?
Reply With Quote
  #6  
Old 03-12-2021, 02:48 PM
macropod's Avatar
macropod macropod is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

That post relates to the use of content controls, not formfields.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 03-12-2021, 02:49 PM
BT13 BT13 is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2010
Novice
 
Join Date: Mar 2021
Posts: 4
BT13 is on a distinguished road
Default

Can I maybe try to explain a little more of what I am trying to do and you can point me in the right direction of how to accomplish it?
Reply With Quote
  #8  
Old 03-12-2021, 02:51 PM
macropod's Avatar
macropod macropod is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I think you should start a new thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide table based on dropdown list Show/Hide content based on dropdown value AOSMITH Word 5 11-19-2019 07:19 PM
Show/Hide text based on dropdown value AOSMITH Word VBA 2 11-19-2019 02:19 PM
Text based on selection of dropdown list cloud67 Word VBA 2 08-09-2019 06:46 AM
Hide table based on dropdown list Auto populate a text field based on Content Control Dropdown List matthias92701 Word VBA 2 05-02-2019 03:54 PM
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet CaptainRetired Excel Programming 18 01-04-2018 07:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 PM.


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