Need Help Understanding {IF {REF}} Fields and FORMTEXT.

Makenzie Miller 1 Reputation point
2021-09-28T16:23:08.723+00:00

I am needing help with a field code I have inserted and it not being editable once it is in restrict editing. I am very new to the world of coding and creating templates and fillable forms but continuously excited to learn more.
Currently I am trying to create a fillable form, that I eventually want to turn into a template, so that when emergencies occur, an already reliable form is ready to be filled. The problem I am having is that depending on a certain selection from a drop down list is selected, an additional information table appears that needs to be filled, but I can't seem to be able to do so.135857-capture1.png

^This is what the form looks like before an editing or selections.

135940-capture2.png

135992-capture3.png

^ And this is what is looks like when you view the field codes. (I know very clustered.)

136002-capture4.png

^But for example, where we go. Once I have it in restricted editing (form fillable setting), I can't seem to understand what to add or change to make the newly additional table fillable.
As in the picture above, lets say we needed to report an injury. The correct incident type is selected and once tabbed out, the appropriate additional table appears. YAY! That is what I need. So, I continue with the next selections and begin filling the first page of the form. All is well and working!
I get to the VERY last section of the first page and hit the table button, hoping it will jump to the next table to fill in the details of the 'Injury/Illness' table. BUT NO! It continues onto the NEXT table of 'CPP Internal Reporting.'
I then decide to click the checkboxes, those work, but the areas where I have [FORMTEXT] so be able to add additional details, it doesn't work!

(I really hope all that I just explained, makes sense.)

I am trying to understand or figure out how to make the table that appears, depending on 'Incident Type' selection, relevant and editable. I keep looking at properties, settings, maybe finding a different way to insert these tables and so forth, with no answers!

Please help!

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
891 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doug Robbins - MVP 716 Reputation points
    2021-10-03T03:21:20.773+00:00

    As you appear to be applying Protection for Filling in Forms, it is assumed that you are using Legacy FormFields and to achieve your aim you will need to:

    1. Select the part of the form that you want to be displayed based on the item selected from the Dropdown and identify it by adding a bookmark to the document (in the following code I used InfoForm as the bookmark
    2. Run a macro on exit from the Dropdown formfield containing code such as (replacing the "ShowInfoForm" with the item which, if selected in the Dropdown will display the additional part of the form.

    With ActiveDocument
    If .FormFields("DropDown1").Result = "ShowInfoForm" Then
    .Unprotect
    .Bookmarks("InfoForm").Range.Font.Hidden = False
    .Protect wdAllowOnlyFormFields, noreset
    Else
    .Unprotect
    .Bookmarks("InfoForm").Range.Font.Hidden = True
    .Protect wdAllowOnlyFormFields, noreset
    End If
    End With

    0 comments