Hello all,
I'm pretty new at Access and I cannot find a solution to my problem.
I'm building a project management database in which I have a form for entry of a new project. A user will enter their new project into this form and then come to a button called "assign members" which I have currently made to open another form called "assign members". Assign Members form has two listboxes in which they can double click on employees from the left to put into the right listbox to indicate that they want these people assigned to this project. The object is for them to click a save button so that the items in the right listbox will save to the record they were creating in the new project form and display to them who they chose once they return to the original form for entering a new project. Then, those members need to be saved to the projects table in a column called "assigned members". I can't even figure out how to save the items from the right list box SOMEWHERE, let alone display them on the new project form. Please help!!