Looking for a Good Example of an Attendance Form Structure (1 Viewer)

Been TOO long that I was away from ACCESS coding, used to be decent. Now, not so much. I have a table for Members, Events and Attendance. Want to get the Members that Attended each event. Have set up the Relationships between the Members to Attendance and Events to Attendance. I can set up a form that requires entering the Event and Member for each new Attendance record. I would like to have a form with sub form that you select the Event and then in the sub form add the Members that attended. Does anyone know of an example Access Database example that I might study for this application? Thanks!

Don't know of a sample, but it sounds like a pretty normal setup, with the form bound to the events table and the subform to the attendance table. Master/child links would keep them in sync. Here's a method for bulk entry:

http://www.baldyweb.com/MultiselectAppend.htm

Oh, and:

http://www.excelguru.ca/node/7

take a look at these two threads

http://www.excelguru.ca/content.php?184

http://www.accessforums.net/showthread.php?t=58063