Save records from a list box to a separate table?

[vstolmech513]

Let's see if I can accurately describe my problem without confusing myself...

I've got a table of names that are populated by a separate form.
I want to use the names in that table to populate a list box on another form but I'd like to be able to select multiple people from this list and store those selected names in a different table, which will be used by a query to make a report. What is the easiest way to accomplish this task?

[Minion]

Depending on the nature of the query you are looking to create and the addtional information you are going to pull into this query it should not be necessary to form an additional table. By setting a Multi Select property of the list box to either Simple or Extended you can have multiple selections.

Next use the ItemsSelected property to return the list of selected values to an array variable. Once these are determined addtional code should allow you to create the necessary query and launch it without the need to duplicate the data in another table.

Again all of this depends on what you are looking to create in the end an what you are working with to begin with.

Hope this helps.

- Minion -

[vstolmech513]

Depending on the nature of the query you are looking to create and the addtional information you are going to pull into this query it should not be necessary to form an additional table. By setting a Multi Select property of the list box to either Simple or Extended you can have multiple selections.

Next use the ItemsSelected property to return the list of selected values to an array variable. Once these are determined addtional code should allow you to create the necessary query and launch it without the need to duplicate the data in another table.

Again all of this depends on what you are looking to create in the end an what you are working with to begin with.

Hope this helps.
- Minion -

Ok, I've already got the multi select property in the list box so I can select more than one name, but I'm lost on how to actually store this information in a new record for whatever date I put in. I'd like the list box to show all names but in the current record I'd like only the names that I selected to show up. From this I'd like to have a button that would print a report containing that information.

[joshapalooza]

Subscribed to the current thread