I've given this a lot of thought and I am still at a loss as to what to do. I'm sure it has been done before.

Here's the pic:

tblFAQResponses is the many side joined by ResondentID.

The form is based off tblFAQResponses. One of the fields in this table is ResponseID (which is a choice of 7 responses). The Respondent CAN have more than 1 ResponseID.

What I can't figure out is how to make these responseId fields easier to populate other than a subform where the user has to manually select each response from a drop down and (essentially) create the records for the table. I would like to have something along the lines of showing the seven responses and allowing the user to check the ones that apply and have that data populate the subform, record by record.

I will be playing with it all day.

Thanks for any suggestions you have.

Ok. I'm getting there through a "OnClick" event to set the value of the field, what I need to know now is IF there is a better way.

Thanks.

Well, I have found some information to help me, but time constrainsts will prevent me from doing things THAT way. I will decidely have to go the "long way around" this time and make improvements down the line.

Thanks for reading the post anyway. If you have a suggestion, I will put in my pocket for a better time.