List box problems

[garyd1234]

How do you put /get items out of column 2 of a 2 column list box?

list42.column(1,list42.listindex) Is this correct and, if so, what do you set listindex = to. My list box populates from a query. I want to write a loop that reads down through the items in the list box and compare the first column item in each row with another variable to search and pull out the second item (second column).

Need help on how to load up a list box in code and get stuff out. List42.additem won't work like it does in VB.
Like Avril Lavigne says "Why'd they have to go and make things so complicated?"
Thanks

 

[Corticus]

Hi garyd1234,

I think the easiest way is to set your listbox's rowsource property to a table or SQL expression. Then set the column count to 2, and set your column widths to something like:
1";1";
adjust to suit your needs

To add/remove items, do something that changes the criteria for a query, or delete or add records for a table source.

Use
Listbox1.requery to keep your listbox's contents fresh after you've altered its source data. Adjust the name listbox1 for your control.

HTH,