Iam using ADO & there r 10 Roll numbers in Roll Number Field. I want to populate combo box at form load event & see all 10 roll numbers in the combo box. I use the code in form load event Combo1.AddItem (rec.Fields(0)) but using it,it only show Roll number 1 in combo box. How can i get the remaining 9 Roll numbers which are in the database? Is there need for loop.If yes then how can i use it or there is any other way to see all 10 roll numbers populated in combo box. 2--My second problem is when i see the 1 in combo box i want to see the crosponding fields by clicking 1 . Suppose i click on 1 at combo box & it will show the Name & address of the stiudent in the text boxes. Please guide me that how can i do that. Thanks in advance for the help.

Put the rec.Fields(0)) inside a While/Wend loop and a move next statement after the rec.fields(0) statement. 2. Use the contents of the combo item selected in an SQL statement. SELECT * FROM addresstable WHERE rollno = combo1 Populate your text boxes with the resultant recordset. Stuart

Populate the combobox like this.... Do while not rsData.eof call Combo1.AddItem(rsData.Fields(0)) rsData.MoveNext Loop