Connecting entries in a drop down field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have 2 drop down fields, one with Course #'s and the other with the
Course names, how do I relate the entries. In other words when I select
123456 from the course # drop down list I want course 1 to prefill in the
course name field. If I select 222444 from the course # drop down list I
want course 2 to prefillin the course field name.
 
Hi =?Utf-8?B?cGF0dHkgYjEz?=,
If I have 2 drop down fields, one with Course #'s and the other with the
Course names, how do I relate the entries. In other words when I select
123456 from the course # drop down list I want course 1 to prefill in the
course name field. If I select 222444 from the course # drop down list I
want course 2 to prefillin the course field name.
Click to expand...
this would require a macro solution, probably linked to the "On Exit" action
of the first of the drop down fields. The macro would have to
- unprotect the document
- evaluate the dropdown entry
- get the data that matches
- write it to the other dropdown
- reprotect the document without resetting the fields

Best place to follow up on this, if you're allowed to use a macro solution,
would be one of the word.vba groups. The .beginner group, if you're not
familiar with macro programming.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Back
Top