PDA

Click to See Complete Forum and Search --> : Populate Combo Box From Access Table


Tayewo
Nov 15th, 2000, 02:40 AM
How do I populate a combo box control on a form from a table in Access database?

Edneeis
Nov 15th, 2000, 02:46 AM
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.

rMax=rs.recordcount
for x=1 to rMax
combo1.additem rs!FieldtoUse
rs.movenext
next x