i did a project similar to this!!
i had a Dummy .mdb file and i needed to create a form that will display the information of students in a MSFlexGrid that where filter by Name or By Courses!!!
if a name was click, it will open a new form that display all the information from the student...
all of this was read from the .mdb file, there you could delete or add classes to the student or if you wanted, you could edit any information of the student!!!!
i used ADO to connect to the .mdb file!!!!
worked like a charm!!!!
try something like this...
VB Code:
Recordset.Open SQLStatement, connection, , , adCmdText
If Not (Recordset.BOF And Recordset.EOF) Then
Do Until recordset.EOF
With listbox1 ' Or Combo1
.AddItem Recordset.Fields("Whatever")
End With
Recordset.MoveNext
Loop
End If