Hi

I have a dropdownbox (dropdown4) whichcontains several countries (Oman, Dubai, Iraq etc)
What I require is that if Oman is selected then in a text field (Text75) then I want this to show "ME"
If Dubai is selected then I want the text field to show "Warm" etc etc

I can do this in excel but unsure how to do this in word.

Any help appreciated.

Which version of Word are you using as there maybe different technics to help you, would you be able to upload a sample of the document as well

Trevor

It is Word 2003 with SP3

I have attached the part of the form that requires the update. The "Loyalty" is the dropdown and the Billing group is what I require to be populated with either PJHQ-ME or PJHQ ROW whatever is selected from the dropdown.

many thanks

Jaycee

Trevor

It is Word 2003 with SP3

I have attached the part of the form that requires the update. The "Loyalty" is the dropdown and the Billing group is what I require to be populated with either PJHQ-ME or PJHQ ROW whatever is selected from the dropdown.

many thanks

Jaycee

Jaycee

I have looked at your document, the form fields only become active when the document is locked and I cannot get word to deal with your way of wanting to deal with this.

What I have done is as follows:

Created a new word document with the small table in and used BookMarks.

Created a userform in the Visual Basic Screen area and added text controls and combination box, plus 2 command buttons.

When the form is activated it will fill the drop down with the location names based on your list. It will also add todays date.

When you select something from the drop down and then click OK it will then place the necessary in the text box based on the drop down selection. It will then fill the document where the bookmarks have been placed.

I have added the option to cancel.

I have then added the code so that when you open the document it will display the form.

If this works for you then you will need to look at the Visual Basic Code so on the keyboard you would need to press Alt & F11 in the left side of the screen you will see a userform called FrmFormFields if you double click it you will then see the controls and if you double click the OK button you will then see the some of the code.

To use this for new documents you will have to save it as a Template so when you create a new document based on the Template the form will show itself each time.