List box question

[LarryJ]

Here is what I am trying to do:



I have a list box with 40 items and I want to be able to click them and copy them into another list box, without losing what is in the destination list box. For example, the first item I click would be copied to the destination and when I click other items they would be copied as well without erasing the contents of the destination. I'm wondering if the destination needs to be something other than a list box. Any suggestions?

[mike60smart]

Why would you need to do this?

[Bob Fitz]

What is the Row Source property of both listboxes and what is the Row Source Type property of both listboxes

[CJ_London]

Would also ask - if a user has ‘copied’ an item rather than ‘move’ an item - can they copy it again?

[Welshgasman]

Why would you need to do this?

Common function Mike?

[Micron]

I'd say not all that uncommon, especially if you move the items from one to the other but I wonder about the copying thing. Why not just multi-select if you're going to copy? I have done this from a multi-select listbox then moved the selected items to another with a button click rather than double clicking each list item.

[LarryJ]

The idea is to take the roster of a baseball team and create their starting lineup, which is why I'm wondering if the destination needs to be something other than a list box. The origin box is filled by clicking the team name in another box and executing a query to retrieve the roster (select * from...). From that, I want to be able to click on the players and create the batting order.

[orange]

LarryJ,

Watch this older video from DataPig (now resurrected) re moving items from listbox1 to listbox2. It may give some insight.

listbox1-- could be team roster
listbox2-- batting lineup

[mike60smart]

Probably but I was just curious as to the process.

[Micron]

The idea is to take the roster of a baseball team and create their starting lineup

Then you need to ensure that the same player cannot be added more than once. How you want to work with the subset of items should probably be the deciding factor as to whether or not to use a second listbox, which can be fine in a lot of cases. Lots of things you could do. One might be to use a staging table where you delete all records before populating with your list choices. Easier perhaps than trying to work with a value list from the 2nd listbox if you want something like a report from your selections.

EDIT - Forgot to say that the table could also handle not allowing the same item to be added again.

[moke123]

Here's a picklist class.

[LarryJ]

Well, this is odd. In the form in your zip file, everything works. But I'm getting a user defined type not defined error when I try to use it in a new form, which seems odd since it works just fine inside what you sent.

[Micron]

user defined type not defined

Most likely you are missing a reference in your own db that the db has where the form works.

[moke123]

Did you add a reference to Microsoft Scripting Runtime?

I believe that's the error if you didn't.

Later versions of that demo are late bound so no reference needed but I didn't have a newer one handy when I posted.

[Welshgasman]

Well, this is odd. In the form in your zip file, everything works. But I'm getting a user defined type not defined error when I try to use it in a new form, which seems odd since it works just fine inside what you sent.

Did you read the code, the form? It says you need a certain reference?