VB6 and Access HELP !

[stmartin]

I'm trying to search an Access database and populate a DBcombo with a certain data ...

In the database I have student Id's and Courses they have taken ... I'm trying to search using the StudentID and then populate a DBcombo box with all the courses they have taken ...

I have the search working and I can send the first line of data to a text box, but I'm not sure how to send all of the data to a DBcombo.

ANY SUGGESTIONS???????

[preeti]

If you are using a datasource, then set the DataMember, DataSource, RowSource, and ListField Properties of the DBCombo.

If you are accessing you database through code: ie Dim x as databaseobject then you could use a regular combo box and then using a while loop, use additem method to add the courses to the combo box:

while not recordsetobject.eof
combo1.additem recordsetobject!fieldname
recordsetobject.movenext
loop

HTH

Preeti