How do I add multiple table entries using check boxes?

[avarusbrightfyre]

I have a database that tracks the performances of various members of my ensemble. What I would like to have is a form that will allow me to specify the name of an event, the date of that event, the type of event it was and then have a subform with a list of names of the people of the ensemble. The goal would be to have the ability to simply click on all of the people who actually did the event, then click a button to add the appropriate entries to the actual table. The end goal of this would be to have a quick way to find out how many performances any one member did between a specified range of dates.



What is the best way to accomplish this?

[pbaldy]

Would a listbox work?

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

[avarusbrightfyre]

Ok, here is what I have so far:

I have a form called "Add Commitment Count", a text box named "Event Name", a combo box named "Event Type" (which draws from a table of event types), a text box named "EventDate" and a list box named "ListPersonnel" (which draws from a table named "List Personnel").

The list box lists the last name, first name and middle initial of the personnel on the table.

I read the part about using a loop with the list box, but I'm unsure of how all the parts work. What I want to happen is that when the user selects all of the personnel assigned to an event, the database will add a new record for each selection using the EventName, EventType, EventDate and all the information in the list box pertaining to the selection. How do I reference the other text boxes and combine it with the info from the list box?

[pbaldy]

This line from the example is taking information from a textbox on the form in addition to the listbox:

rs!OtherValue = Me.txtOtherValue