saledan
07-08-2008, 08:48 AM
Hi to everyone.
I have an issue with listbox.
When click on a button, i run a query with ADODB and I use
Do Until rec.EOF
Loop
to get each result from the query.
I have a listbox with 6 columns, and i would like to populate the listbox with the query results, but with .addItem function, for example
resultSearchListBox.AddItem (rec.Fields("surname").Value) i add value just only into the first column. How can I add values into the other columns, for example rec.Fields("name").Value into the 2nd...etc..?
I tried some times with different codes, but I always received error from execution or add value in the first column.
Please may you help me?
Thanks a lot
(p.s.: sorry for my english, i hope that you understand my issue)
I have an issue with listbox.
When click on a button, i run a query with ADODB and I use
Do Until rec.EOF
Loop
to get each result from the query.
I have a listbox with 6 columns, and i would like to populate the listbox with the query results, but with .addItem function, for example
resultSearchListBox.AddItem (rec.Fields("surname").Value) i add value just only into the first column. How can I add values into the other columns, for example rec.Fields("name").Value into the 2nd...etc..?
I tried some times with different codes, but I always received error from execution or add value in the first column.
Please may you help me?
Thanks a lot
(p.s.: sorry for my english, i hope that you understand my issue)