selecting a data from combo box

HI!
On a form I have a combo box and 6-7 text boxes. The list of items in combo box is a list of names from
a table in SQLServer using ADO connection. Now I want to retrieve data pertaining to the selection made in
combo box and put the data into all the 6-7 text boxes.....I want to basically update a record in a table selected
thru the combo box.
can anybody help?