SQL and VBA

Can someone show me how I can use a SELECT statement from within VBA (in Access). All I want to do is retrieve all of the names from a table and add a specific field from each returned rows into a ComboBox.

e.g.

Perform the query...

SELECT empid, name
FROM employees;

... and then add all 'name' fields from the returned rows to a ComboBox.

Thanks.

Here's a sample piece of code that populates Combo1 when the form is opened.

VB Code:

Private Sub Form_Open(Cancel As Integer)
    With Me.Combo1
        .ColumnCount = 2
        .Width = 2440
        .ColumnWidths = "0;2440"
        .BoundColumn = 1
        .RowSource = "SELECT BRAND_ID,BRAND_DESC FROM PH_BRAND"
    End With
End Sub

I've used a select from my table, just change the SQL statement to point to your table

Ah, that seems simple enough. Thanks.

Could you also tell me how to do the same, but receive the data as an array of strings? I can't see how I would adapt your example to make it do this...

Use ADO and a recordset object.

Search the forums or tutorials online there are loads of examples.


Using the array to fill the combobox might be a problem though in access ;) requires special coding.