How can I automate a field (linking it to a drop down)

[Wouter WES]

Dear Sue,

First of all thank you for all your support. I also have ordered your book.
Shipping to France will take some time.

In the mean time I hope that I will be able, with your earlier instruction,
to publish my newly developed Contact form without too much problems.

Also, please allow me a new question before I publish this Contact form.

My question is:
I created a dropdown field, containing names of local medical practitioners
(MPs). Next to this field, I created another field for the corresponding MP
telephone number (drop down or text). Once a MP is selected from the drop
down, I have to manually type his / her corresponding telephone number in the
field (text). How can I automate this field so that once I have selected a MP
his corresponding telephone appears in the field next to his name?

Thank you,
Wouter

 

[Sue Mosher [MVP-Outlook]]

You would need to put code behind the form to react to the user's
interaction. The page at http://www.outlookcode.com/article.aspx?ID=38
explains what events are involved and how to set both property values (which
is probably what you want) and control values.