Using Checkbox to append another table

[fountain27]

In my DB project i have created a form with Company information and then a subform to display all the contacts associated for that company. I would like to select certain contacts of the company using a checkbox to append the selected contacts to another table. Ultimately, we are selecting individuals who are signing-up for training courses. The other table will be used for planning courses, name badges, future communications etc.

I have searched the a few different options, but I thought I would ask if anyone has done something similar and their recommendation. I am also not married to the current set-up so I could take a different approach if that makes it's easier.



I appreciate the time to reply.

[ranman256]

I have a 'temp' table called tPickedList. ID, Name, Picked (y/n)
here I load a list seen in a form listbox, and user can check mark it yes/no by dbl-clicking
(sometimes the checkbox is not even needed, since the items in the list are the 'chosen=yes')

[fountain27]

Thank you so much. That is very clean.