Hello

Fist - thank you to all the users of this forum - this is a great place to learn Access!

Can I use check boxes in a form to create and/or remove records in a junction table?

I have a database for technical articles - my question relates to assigning subjects to the articles. I have one table that includes an ArticleID (auto-number) and ArticleTitle among a few other fields. I also have a subject table with SubjectID (auto-number) and Subject (short text). I used a junction table to allow for the many-to-many relationship between articles and subject.  Currently, I have a form to enter article data and sub-form with combo-boxes to assign the subjects to each article. But with over 30 subjects, this is a clunky interface.

For me, a better interface would be for the sub-form to show all categories with a checkbox next to each so I could easily check the ones that apply to each article.  That way I would not need to drop down the combo box and scroll through the list for each subject.  I cannot figure out how to make that idea work. Is there a practical way for someone with limited VBA experience to do this?  

Thanks again