I have repeating values in my combo box, i do want the values to repeat...any idea how to do that ? The reason is that i am taking the values from my database table "Incomplete " from the "Topic" column....The values repeats it self cause it shows all the values in the column including repeating ones....Anyone know what to do ? I have also included my codings......
Code:
Dim data As DAO.Database
Dim rec As DAO.Recordset
Private Sub Form_Load()
Set data = OpenDatabase(App.Path & "\Test Editor.mdb")
Set rec = data.OpenRecordset("SELECT * FROM Incomplete ORDER BY Topic")
rec.MoveFirst
Do While Not rec.EOF
Combo1.AddItem rec.Fields("Topic").Value
rec.MoveNext
Loop
End Sub
Comment