Combo Boxproblem

[Pencilboy]

I am trying to get a combo box to show only the row of data that I select from the combo box. I have set up the box and I do not know the code or if it is possible to even have a combo box do the function. It ismlike a scroll function. I want the whole row of data to be shown when I pull the name up in the combo box?

Any help would be greatly appreciated!

[jubangy]

right click on your combo box hit format control
goto control tab
in the dropdown lines box enter only the amount of cells your using or less
eg..3 rows with info in it so enter 3 in dropdown line box