Printable View
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???????
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