How do I create a multiple selection option within my document?

[Big Rob]

Hi There,

I'm creating a document template that needs to have one of four sets of bank
details displayed on it depending on the currency selected from a drop down
field. The format is planned as follows...

------------------------------------------------------------------
¦Currency ¦ Account Name ¦ Account Number ¦ Sort Code ¦
------------------------------------------------------------------

I've set up the table and created the currency selection field but I am
unable write a formula that will display the remaining information.

All help will be gratefully received.

Thanks, Rob

 

[Doug Robbins]

Are you saying that you have a dropdown type formfield in the currency
column and that depending upon the currency selected, you want to populate
the Account Name, Account Number and Sort Code columns with data that is
relevant to that currency.

If that is the case, you could put text formfields in each of those columns
and set the .Result of each of those formfields with the respective
information based on the .Value of the currency dropdown, using a macro that
runs on exit from that form field.

The macro would make use of the Select Case Statement. Check it out in the
Visual Basic Help file.

--
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