Multi select listbox

[DS]

I have this listbox that I can select one entry to update and delete. I
can also update and delete all of the records. But duh, I've seem to
have forgotten about Updateind and deleting some records. Basically,
how does one set up a simple Multi select to do that. Any basic primers
out there?
Thanks
DS

 

[John W. Vinson]

I have this listbox that I can select one entry to update and delete. I
can also update and delete all of the records. But duh, I've seem to
have forgotten about Updateind and deleting some records. Basically,
how does one set up a simple Multi select to do that. Any basic primers
out there?
Thanks

That's a lot harder. A Multiselect doesn't have a value; you need to write VBA
code to loop through its ItemsSelected collection to do anything with it.

A simple continuous Subform is a *whole* lot easier - you can display the
records, update them in place, delete them, whatever.

John W. Vinson [MVP]

 

[DS]

That's a lot harder. A Multiselect doesn't have a value; you need to write VBA
code to loop through its ItemsSelected collection to do anything with it.

A simple continuous Subform is a *whole* lot easier - you can display the
records, update them in place, delete them, whatever.

John W. Vinson [MVP]

I think I'll abandon the Multi-Select thing. First I have the problem
if the quantity of the item is more than one you'd have to prompt
somewhere to ask if you want to void all or one.

1 Hot Dog
5 Hot Dogs
3 Hot Dogs
1 Hot Dog

Unless you ask before hand, but even that can get messy. So I guess the
multi-select thing would be ok if each records quantity were one. Or
perhaps if they address the quantity issue before the looping happens.
Just thinking out loud.
Thanks
DS