Make one field autopopulate when another is chosen...

[dCp]

I have a simple two-table db. The first table takes in some user info, and the second contains a controlled list. The user picks an entry from a drop down list (populated from the second table),and what I want is a field in the form the user is filling in to automatically change when a user has picked the entry from the list. The user picks a username from the list, and I want the users name (contained in the same table as the username) to pop into the next field in the form. I know I have to use an on-update event, but I am not sure what to do after that

Thanks,

dp.

 

[LonnieJohnson]

As the row source for your combo box you need to include both fields (...or coulumns). The second column being the user's name. Now on the after update event of the combo box you will code.

YourTextBox = YourComboBoxName.Column(1)

Hope this helps... B-) ljprodev@yahoo.com
Professional Development
MS Access Applications