I work with a database project. Now I want to show all data (from a table like 'student name' column) in a combo box. how can I do this. I connect the database by system DSN and adodc control. plese any body help me.

If I select a name or ID from this combo box how the all data of this person's will show in data report.

you need to open the recordset as per selection of the combobox input and pass the same recordset to report.

Please details. your answer I don't understan.

The query that you are using to frame the query needs to be framed dynamically by input from combo and passed to report.