Please I need help. How do I  bind a combo box to an access table so that the combo box would read the content of the access table.


[Edited by vbgen on 07-03-2007 at 12:42 PM GMT]

Its simple
Take that field in recordset and add in combo
e.g
Dim rst As New ADODB.Recordset
rst.Open "select nbranch_code,vcbranch_name from branch_master", conn, adOpenDynamic, adLockOptimistic
'If rst.RecordCount > 0 Then
If Not (rst.EOF And rst.BOF) Then
With rst
    cmbbranch.Clear
    .MoveFirst
    Do Until .EOF
        cmbbranch.AddItem .Fields(1)
        .MoveNext
    Loop
End With

-----------Try It

Either there's a special combobox for ADO stuff, or the normal control has "datasource" and other properties -- HOWEVER it requires a ADO data source or such on the form as well.  It is easier to just populate the combo box with the data from the database yourself.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)