LIST BOX

[levis501]

I'm sorry guys.... May be U think I'm really stupid 2 ask this question..... but I really don't know..... because... I'm beginner in exploring this VB software.....

I've a question 4 U.....

How can I list one field.... in listbox....
4 example I've Item table.... and I want to list Item_ID (field).... I'd try to coding.... but the list doesn't come out...

Do me a favour.....

-Beginner-

[This message has been edited by levis501 (edited 01-05-2000).]

[LG]

Hi.
Are you in the same class with Smie?

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("au_id")
Rs.MoveNext
Loop

End Sub

Larisa