lsit box - database

How can I populate a list box with the info from a database field.

Thanks

JO

Assuming you know how to open a database and set your data controls.

While Not Data1.Recordset.EOF
List1.Additem Data1.Recordset!databaseFieldName
Data1.Recordset.MoveNext
Wend

then close up shop and be on about your business

Thanks-a-bunch

I get an error when I put that in the Form_Load event but it works with a Command_Click. Any ideas on how to use this in the Form_Load event

Try it in Form_Activate

That works, I appreciate it

JO