Unanswered: Access 2003: Multiselect listbox - saving and restoring
Database created to enter workplan for the Section, which has tables for Staff, Team, Objectives and Activities. Each objective has one or more related activities, and each staff member belongs to only one team. There is an objective form and activities sub-form.
Each activity may have one person, multiple people (same or different teams), an entire team or multiple teams working on it. As such, I added a listbox which is populated by a query which unions the staff and team tables to provide a list of all staff and teams. My desired outcome is twofold:
1) Make selection(s) from the listbox and save to a table (or field?);
2) Be able to reflect the selections when the forms are being browsed.
I have not created the table (or field?) to house the listbox selections yet, since I'm not sure what I'll be saving to it. I will also be generating reports, but I'm hopeful that if the right data is saved this should not be too traumatic.
Hope this isn't too long and I am clear. Any assistance that can be provided will be greatly appreciated!
I think you are trying to accomplish something that shouldn't be attempted -- using a multi-select list box instead of defining and using table relationships.
Relating these tables with 1 objective to M assignment and 1 person to M assignment creates a many to many relationship between person and objective. Design forms and subforms to support that platform and you won't need multi-select list boxes, nor do you need to write the code needed to store and retrieve the data that such a list box has selected.