Drop down list

Hello everybody!
I have a little problem here.
I am trying to make a form with one drop down list (Name for example) and a few other fields (phone,email,etc), all which I want to import from one table.
My actual problem which I do not know how to do is the fact that when I change the Object from the list (Name) I want the other fields to adjust themselves to the info (phone,email,etc) of the new one, how do I do this?
I know this might sound really strange or not make too much sense, but help would be appreciated.
Thank you

You could include the other details (phone etc) as hidden columns in your combo box and then use a reference to these columns as the Control Source property of a text box for each column.
If however, the other details are in a table on the may side of a one - many relationship you may want to use a subform or perhaps a list box to display them.
EDIT
Also search the forum and google for Cascading Combo boxes

CrossPost: http://www.accessforums.net/forms/drop-down-list-41580.html
Please read: http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters