Maria wrote:
<< function that takes a Collection and returns its members in a properly
separated string; >>
It does depend a bit on what exactly is in the Collection.
Air code:
function EnumColl(coll as collection)as string
dim item as variant
dim cRes as string
for each item in collection
cres=cres & item.value & ";"
next
enumcoll=left(cres,len(cres)-1)
end function
<< event handler that removes the item from the collection. Re-filling the
list is an option.>>
Form is open in design view? Good. Select the listbox, view Properties,
tab Events; choose [Event Procedure] for onClick.
Click the three dot button. If you are presented with three options,
choose the one similar to "write code" (what was that again?)
Put this inside:
yourcollection.remove yourlistbox.listindex
If it doesn't remove the right one, you might have to put
yourcollection.remove yourlistbox.listindex +1
the optional part is then
yourlistbox.rowsource = enumcoll(yourcollection)
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea