[Resolved] Access VBA - Listbox Additem equivalent

Hi Guys,


I'm trying to add table data from the current M$ Access recordset
into a (VBA) ListBox.


Can't figure out the syntax tho.
Eg: What is the VBA ListBox equivalent of (ListBox) .AddItem?



Regards,
Bruce.

create a string, sItems (semicolon delimited, I think)
then
List1.RowSource = sItems

Just make sure you've changed the listbox RowSourceType to value list first..

Erin

I'll give it a go......

Thanks guys, that worked :)



Bruce.