List Box Columns

[Pwyd]

How does one programmatically assign something to the second column of a
listbox?

I was going to use a combo box, and set its after update property in order
to run a query that puts a pair of counts in a seperate listbox, filtering
for only those records associated with whats contained in the combo box.

 

[Dale Fye]

I generally use queries as the RowSource for my listboxes, but you can set
the RowSourceType to "ValueList". Then use the additem method to add items
to the list. The key to this is if you want the list to be multi-columned,
you need to concatenate the various column values (use the semicolon as the
column seperator) into a single string for the additem method

me.lst_Something.AddItem "1; This is the text in column 2; Column3"

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.