How do I populate a combo box control on a form from a table in Access database?
Printable View
How do I populate a combo box control on a form from a table in Access database?
you can use a datacombo and just set the rowsource and listfield properties. Or to use a normal combo you'd have to step through the recordset.
Code:rMax=rs.recordcount
for x=1 to rMax
combo1.additem rs!FieldtoUse
rs.movenext
next x