Dropdown form fields

[Slam]

I am creating an A5 landscape doc. which will repeat
twice and print on A4 portrait, to give two copies.

I have some dropdown boxes and when a selection is made
on the first form I want the second form to reflect the
same choices. I believe this is done via a macro but I
can't make it work!

Can you point me to a web site which will explain, in
straightforward terms, how to do this, please?

Thanks.

 

[Doug Robbins]

Unless you want to give the user the option of changing the data, in place
of the dropdown on the second "form" insert a cross reference to the text of
the bookmark assigned to the dropdown on the first form and set the
Calculate on exit property for that formfield so that the cross reference is
updated after the user selects the entry and then exist from the field.

You will have to be careful that the entries in the dropdown list for each
of the formfields are identical.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Doug Robbins]

Forgot to include the code

With ActiveDocument
.FormFields("Dropdown2").DropDown.Value =
..FormFields("dropdown1").DropDown.Value
End With


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Greg Maxey]

I don't think it needs to be a macro solution. Actually I don't think you
need a dropdown in the second form. You could set the first dropdown to
calculate on exit and then reference it's bookmark in the second from.

{ REF Dropdown1}