Microsoft Word Legacy Forms

Question

I have a two part question........ I thought I had some knowledge, but i feel like an amateur - as i have spent way to much time on this form.  Please keep in mind that this table will be protected when it reaches the team members.  

Part 1:

I am creating a form using the control buttons in Legacy Forms.  I want to add an "If-Then Statement" to the form right next to a Form Drop Down named "QCRequirements".  i would like a text to automatically populate if the answer is Yes.  If Yes - Please route to John.   

i have tried  **{IF order>=100 "Thanks" "The minimum order is 100 units"}**but it just doesnt work. :( and i think it is because it will be a protected form.

Part 2:

In this same form, I have a separate table in excel that contains the "Department" (30 Departments and or rows) & "Department Managers"  in some cases i have up to 3 managers.  In the form, what i would like to happen is a table to appear that automatically generates the managers name (of a specific department), as i need to get a signature next to everyone's name.  i would like the table to appear as below so they can sign in the box:

Manager's Name	Manager's Signature	Date Signed
Manager 1
Manager 2
Manager 3

and it would pull this info from another field named "DepartmentRequesting"

Please help me.......... and i know i may have missed some details, but i tried to be as specific as possible.  

[Moderator note: this question has also been asked in the Word section of the MSOffice forums athttps://www.msofficeforums.com/word/43029-word-legacy-form.html.]

[Moved from Word / other/unknown /Office 365 for Business]

Answer 1

Assuming that QCRequirments is the name of the bookmark assigned to the dropdown, at the location in the document where you want the text to appear, use the following field construction

{ IF { Ref QCRequirements } = "Yes" "Please route to John" "" }

using CTRL+F9 to insert each pair of field delimiters { } and ALT+F9 to toggle off their display.  You will also need to check the Calculate on Exit box in the Properties dialog for the QCRequirements formfield.

In view of Part 2 of your question however, I believe it would be a lot easier to use a userform and for information on that, see the following pages of Greg Maxey's website

http://gregmaxey.mvps.org/Create\_and\_employ\_a\_UserForm.htm

http://gregmaxey.mvps.org/Populate\_UserForm\_ListBox.htm

Answer 2

It should not make any difference if you are using a table.

If you send me a copy of the document, referencing this thread in the covering email message, I will investigate the issue.

Answer 3

Part one - This didn't work. :( 

Could it be..........because i put it in a table?