"Jerry Boone" <je***@gomaps.com.nospam> wrote in
news:44**********************@news.hubris.net:
This is playing dirty, but you can set your row source type to "Value
List" and then loop your recordset to build a string representing the
value data.
Last but not least assign the string value to the control.rowsource
property in code. Not sure, but there may be a limit as to how long
that string can be so watch out for that.
I think you can do the callback function stuff as demonstrated in GETZ
(see Access 2000 Dev Handbook, vol 1, pg 401 to get around the problems
associated with building up a string for the Value List.
Use the Getrows method to get the recordset's data into a Variant array:
dim rs as variant
dim adors as ADODB.Recordset
....
rs = adors.getrows
'this will need to be transposed, or you can just walk it in code, but
'the order is field x record...