## populating a text box

hey to all!!<BR><BR>now heres my qestion..<BR><BR>i have two textboxes. lets call them text1 and text2 respectively. <BR><BR>in text1 i have populated it with the usernames from the database. thus it is now a combo box.<BR><BR>now when the user selects his/her username then i want the text2 to show his office name automatically from the database.<BR>how is this possible..<BR><BR>it would be helpfull if someone would give me the code for doing this as im cranked up trying diff stuff.<BR>thanx in advance<BR>