Multicolumn listbox add item

[is49460]

Hello!

I have two textboxes and a multicolumn listbox on the form. User enters first name in one textbox and last name in the other. After "submit" button is clicked I want first and last name to be displayed in the listbox (first name in column 0 and last name in column 1). Can anyone help me with what list function I should use?
I've tried using listbox.additem function passing array as parameter, but that does not work.
Any help would be greatly appreciated.

[Rabbit]

AddItem only works if the listbox is set to value list. And you don't pass it an array, you pass it a string.

If it's a table/query, then you can use a .Requery to refresh it.

[is49460]

i have it set to "value list" and the reason i was trying to pass an array is because its a multicolumn listbox.
I used list1.additem string1 on listboxes with a single column, but I cant figure out how to apply it to populate values in different columns

[Rabbit]

Even with a multicolumn listbox you pass it a string.

"Value1;Value2;Value3"

[is49460]

Thanks a lot. I spend hours trying to find it online... and all i had to do is separate values with semicolons.
Thanks a lot!!!

[Rabbit]

Not a problem, good luck.

[Gorj]

Lol... I've done the exact same thing... Hours searching.

Thanks