How to Populate List or Combo box with Recordset

[Akin walter-Johnson III]

ALL,
I need to populate a list box using ADO record set, can anyone help ?

 

[Arvin Meyer]

ALL,
I need to populate a list box using ADO record set, can anyone help ?

Use the same SQL statement that you used to build the recordset as the
RowSource for the List box.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Akin Walter-Johnson III]

What if the recordset was is from ADO or DAO based
Thanks

 

[Akin Walter-Johnson III]

What if the recordset has to be created using ADO or DAO from another
datasource not local
Thanks

 

[Akin Walter-Johnson III]

What if the recordset has to be created using ADO or DAO from another
datasource not local
Thanks

 

[Albert D. Kallal]

Well, as mentioned, it seems silly to load up a recordset, and then use that
to load up a list box.

However, you can certainly take the data from that recordset and fill the
list box.

You can use a call back function to accomplish this.

Check out:
http://www.mvps.org/access/forms/frm0049.htm

I don't know if ADO has a absolute position, but if it does like DAO, then
you effective map the recordset to the listbox by using the call-back. You
can also send the recordset to an array via getrows (check help on getrows),
and then again map the array to the listbox if you must.