I am working on a Visual Basic program using adodc to write and read from an Access database.
I have the following code:

Private Sub Form_Load()

With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\DataBase.mdb;Persist Security Info=False"

.RecordSource = "select FName from Table1 order by Fname"
End With

End Sub

I want to fill the list of a combobox with the names that the query returns. Please help!
Thanks in advance!