Smie
Jan 5th, 2000, 07:29 AM
How would I load a column (col) from a database table into my listbox? Thanks
LG
Jan 5th, 2000, 08:27 AM
Hi,there!
Here is a code:
Private Sub Form_Load()
Dim Db As Database
Dim Rs As Recordset
Set Db = OpenDatabase("BIBLIO.MDB")
Set Rs = Db.OpenRecordset("AUTHORS")
Rs.MoveFirst
Do Until Rs.EOF
List1.AddItem Rs.Fields(1)
Rs.MoveNext
Loop
End Sub
Good luck.
Larisa