Access97 Listbox Control

[aaronh64]

I am trying to add records from an Access Table into a listbox. Unfortunately, I am maintaining a form which was developed in Access. The Listbox control in access does not support the AddItem Method. Any suggestions on how I might add records to this Access97 listbox (without using the wizard)?

Thanks

-Aaron

[Aaron Young]

All you do is Create a Semi-Colon Delimited String on Items and Assign it the the RowSource Property, making sure the RowSourceType Property is set to "Value List", eg.

List1.RowSourceType = "Value List"
List1.RowSource = "Item1;Item2;Item3;"




Aaron Young
Analyst Programmer
adyoung@win.bright.net
aarony@redwingsoftware.com