I have to do this everyday each with different combination. So its cumbersome to manually refer each entry each time I want to key in the strings.

Let say I have this data
Data.A:
-John


-Chris
-Abdul

Data.B:
-eating
-dancing
-cooking

I want Data.A to appear in drop-down list and Data.B to appear in Label field besides it. I got no problem with drop down list, the problem is to link those forms.
I want when I click "John" from the drop-down list, "eating" would appear in the label form.
The actual data is much longer and I'm planning to do cascading entry menu for Data.A if this works.
Can anyone help me? or provide some sample VB code for it.
I have very basic knowledge with VB as I watched few VB videos

Hi areriff,

The following assumes you're using legacy formfields.

You need a different approach for the second field. Instead of using a formfield, use ordinary IF fields coded as:
{IF {REF DROPDOWN1}= "John" "eating"}{IF {REF DROPDOWN1}= "Chris" "dancing"}{IF {REF DROPDOWN1}= "Abdul" "cooking"}
where 'DROPDOWN1' is the internal bookmark name assigned to your dropdown formfield. No vba is required. All you need to do is to check the Dropdown formfield's 'calculate on exit' property.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

After experimenting a bit. I can't get one value to work at all. I just didn't know what went wrong. I've wrote down few versions and your version of IF field, but how do I makes the text appear? I dissappeared. Do I need to put the second text or label field? Could you provide a little sample of 3 items here? I need to see how it works.

The things that I got in mind is kinda like usual app installer where when we choose 'Full Install', it would display the description of what 'Full Install' is. It would be nice if it is a combo box but without the little triangle on the right (for printing purpose).

I may create a table to separate those two in two columns.

I admit that although I use Word for years, I never you use forms before. But now it would save a lot of time each time because each 'description' would take around a minute to type in. There are dozens of 'description' that carries unique 'ID'. :-(

Hi areriff,

See attached. Simply select an item from the dropdown, then tab out of it. After creating a formula field and updating it, disappearance is quite normal - depending on what the field is doing. Pressing Alt-F9 toggles the field code display on/off.

Attached Files

Dropdown.doc (33.0 KB, 32 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks again... The forms are all alright. I just forgot to restrict the documents.