I've seen a lot of YouTube examples of how to create the tables for MYM but not so many with good examples of how to update that pesky junction table. This DB has two example forms that can do the job.




Below form is the familiar looking form/Subform arrangement, with the main form supplying one FK to the junction table and the subform supplying the other FK. This form has the ability to update both the underlying tables of the main form and the subform as well. The subform dropdown has code to add Event records via the 'Not In List' event. Kind of an all-in-one-form functionality.

Click image for larger version. 

Name:	form-subform.png 
Views:	26 
Size:	23.4 KB 
ID:	41053

This form features side-by-side listboxes. When an Event is chosen with the combo, the right listbox shows Members currently assigned to the Event, while the left listbox show all the others. You can move Member names from one to the other via arrow buttons or by double clicking the name. This form also lets you run reports to show various Member/Event assignments.

Click image for larger version. 

Name:	SideSide.png 
Views:	26 
Size:	32.1 KB 
ID:	41054

MTM Medley-davegri-v01.zip