Add New records and populate existing records via listboxes in forms.

[New.User]

Hello All,


i have started to try my hands on access but have hit the wall for some requirements.
The requirement is I have a many to many relationship between tblTeachers and tblStudents. Currently there is only one teacher in tblStudents and three students in tblTeachers. I also have two multiselect listboxes in a form. When i click on the teacher name in first listbox the three students name get populated in second listbox.
Now I want a scenario where in if i add a new teacher i must be able to select one or two or all three students (under existing teacher) and populate them. What I do not want is all three existing students getting populated automatically to the new teacher.

[davegri]

Generic-EventsSchedule V001.zip

See attached for example of how to manage a many-to-many situation via listboxes.
The "Events" could be teachers and "Members" could be students, or vice versa.

[New.User]

Thank you for the reply. i saw your DB but could not derive the information I needed. Pardon me as mine is a simple db but the one you sent had a lot to digest.

[New.User]

After a long time I was able to find a solution for my case after looking into your sample DB. Thank you

[davegri]

Glad to hear that. If you have any questions about the DB or how to make it work for you, you can PM me or post here.