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.