I'm trying to create a form that will enter information into a junction table. I have a many-to-many relationship between two tables: Events and Contacts. The purpose of this form is to assign people in the Contacts table to a particular event. Ideally, I would like to be able to see an event record on one side of the form and a list of Contacts on the other side of the form and by double clicking the Contact record while the current event is selected will insert a record into the Junction table indicating that that Contact has been selected for that event. Any ideas of where to start?

List box control
and an Append Query based on the selected item in the List Box Control

I have a sample database that shows how to handle many-to-many relationships. If you'll send me an email with "many-to-many" as the subject, I'll send it to you.