MS Access 2000 selection dialog box

[dragonman777]

I am making a database that will list the projects my company is working on. One of the fields needs to hold the "Project components" of a given project. A project may have more than one component.

How can I make an interface that allows me to select multiple components and save them to the record? An interface with the available components listed on the left and the project components on the right would be optimal, it would be similar to the dialog box used in Outlook Express when selecting who to send, cc, and bcc an e-mail to.

Thanks!

 

[SimonDavis]

Do the projects have a lot of components?

There might well be a better answer to this, but the way I would do this is to add a yes/no field to the table for each component, and have each as a checkbox on the form.

This will give you the flexibilty to sort/filter using components (if that's useful).

There might be a way to consolidate all of those in a custom control, like you suggested, and that might be what your original question was, if so sorry . . .

 

[dragonman777]

I wanted to avoid the checkbox list, there may be many many components to each project. A co-worker found an interface called MultiPik in a developers kit that I am going to use.