We help IT Professionals succeed at work.

Infopath - Populate a text box depending on the selection of a dropdown list

daleoran
daleoran asked
on
1,934 Views
Last Modified: 2007-11-29
Hi there,
couldn't find an Infopath section hopefully this section is close enough :)

I've just created a form to test this out to see if it can be done - I've created the form based on a connection to a database. The database contains 2 fields - FullName & EmailAddress.
The form contains two controls -
A drop down list - linked to the FullName Field
A text box - this I want to update depending on the selection in the drop down list.

If Employee 1 is selected from the drop down I want that employees email address to populate the text box.

Can this be done?

Many thanks in advance

Michael
Comment
Watch Question

Freelance
Top Expert 2006
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Author

Commented:
Hi bruintje,
many thanks for that - it works a treat :)
InfoPath is a piece of software I had never heard of until recently and it seems to be a wonderful program :)

Again many thanks.

Michael
Brian MulderFreelance
Top Expert 2006

Commented:
Michael thanks for the grade,

yes it looks wonderfull indeed, there is a learning curve which i guess will keep a lot of people from using it while they still can build on their current knowledge about html/xml/vb/excel/word etc..... maybe i'm over emphasizing the usefullness but to me it looks like this application could replace a lot of the current build custom applications for intranets.

but of course it will take another 5 years to prve me right or wrong :-)

in the meantime we enjoy having it around, see also
http://office.microsoft.com/en-ca/training/CR061832771033.aspx

Brian
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.