update table based on value checked in related table's subform

[nnej]

Here's another question. I have two tables - one is a "family member" table and the other is an "events" table. The tables are linked one to many to allow tracking of which events are attended by which family members.

I would like to be able to easily add records to the events table. My goal is to not have users search by family member to select an event that was attended. I'd rather have a display of all family members (sorted/grouped by city etc) and allow users to check off whether the family member attended a specific event.

My initial thought is having an "events" main form which lists the event description at the top, and a "family members" subform underneath with some sort of extra field that the user can check/update that will add a record to the "events" table. Problem is, I'm not sure what the "check/update field" should look like and how the event would work. (My VB is rather rusty these days.)

Any ideas? Or other suggestions for how to accomplish this?

 

[nnej]

Er... just realized I need a many-to-many middle table between the "family" table and the "events" table. But the basic question still applies - how to easily add records to this middle table?

 

[pbaldy]

I'd probably use a multiselect listbox to display the family members. Upon clicking a button, you'd add the selected members to the table (getting the event from the form). Searching for multiselect will turn up the code to loop through selected items.