How can I populate a list box with the info from a database field.
Thanks
JO
Printable View
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