How to Populate List or Combo box with Recordset

  • Thread starter Thread starter Akin walter-Johnson III
  • Start date Start date
A

Akin walter-Johnson III

ALL,
I need to populate a list box using ADO record set, can anyone help ?
 
What if the recordset has to be created using ADO or DAO from another
datasource not local
Thanks
 
What if the recordset has to be created using ADO or DAO from another
datasource not local
Thanks
 
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.
 
Back
Top