ThadNZ

I'm trying to query my Mysql db to get info onto a combo box for a clien tlist (cmbclient).

I'm trying to populate a combo box with values returned from my Mysql DB. I can get the query to run ok. but i dont know how to feed the output into the combo box. Can anyone have a look at this for me. i'd be very appreciative.

Cheers
Brian



Code:

Dim sql As String

CloseRs

sql = "SELECT * FROM cl_master Where cl_name"
Set rs = cn.Execute(sql)
CheckError

Flyguy

You have to loop through all records in the recordset and add each item to the combobox

ThadNZ

OK,

So i've added the below code, but still nothing. I dont know muh anout sql querying, but is there anything obvious i'm leaving out here?




Dim sql As String
Dim Cl_Name As String

CloseRs

sql = "SELECT * FROM cl_master Where cl_name"
Set rs = cn.Execute(sql)
With rs
Combo1.Clear
Do While Not .EOF
Combo1.AddItem .Fields(Cl_Name).Value
.MoveNext
Loop
End With
CheckError