Results 1 to 2 of 2

Thread: Populate Combo Box From Access Table

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 2000
    Location
    Lagos, Nigeria
    Posts
    50

    Lightbulb

    How do I populate a combo box control on a form from a table in Access database?

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width