Fill combobox from recordset

[D.W. Schingenga]

I want to fill a combobox from a recordset. I building the required records in a recordset. Now I need to get the data in the combobox. I know the AddItem method, but do not know how to use this with a recordset.

Dirk

 

[Mile-O]

Why a recordset and not just a query?

 

[D.W. Schingenga]

Yes you are right, however I am dealing with a SQL Server Dbase and this does not allow me to filter a query with [Forms]![Formname]![txtfield]. I need to build a query that will filter on CustomerNo, that is chosen on a Form.

Dirk.