Multi select listbox

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
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
Click to expand...

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]
 
John said:
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]
Click to expand...
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
 
Back
Top