Member Avatar for mozy40

ok i'm want to populate dropdown with fields from a table in database(sql). Please help!!!

  • 2 Contributors
  • 1 Reply
  • 40 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

Try the following -

rs.Open "SELECT * FROM MyTable", cn, adOpenStatic,adLockOptimistic
Dim x As Integer

If rs.BOF = True Or rs.EOF = True Then
   'No records to show
      Else
   For x = 0 To rs.RecordCount
      Combo1.AddItem rs!MyFieldName
      rs.MoveNext
   Next x
End If
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.