InfoPath Dev

This feels like it should be simple but I can't figure it out. I have a simple access database with a list of usernames and passwords linked to an infopath form. What I want is that when you select one of the usernames from a drop down list, it automatically fills in the password field so it can be printed off and given to said user. I've managed to populate the drop down list with the usernames but nothing I've done has managed to add the associated password.

Hi,

 The Secondary DataSource does it contain the username and the password?  This is needed from the beginning (Pay attention, doing so has a serious security risk)  I would never use InfoPath ore a simple way to show passwords.

 In case both data are available., set as default value of the password the field Password and add a filter saying usernaée = UserNameTextBoxValue

 

No real security risk here, it is intended for reception to hand out temporary usernames to people when the IT staff are unavailable to create an account properly. That solution worked just as hoped, thanks.