Multiple Combo boxes with same list autopopulate the same selection in a form.

Question

I have a form with multiple combo boxes. The purpose of the combo boxes is to store either one or multiple values into a specific table. Table [UnanswereQues] contains fields UnansweredID, AppID and UnansweredQues1-21. I created a Combo box that saves the look up into the Table I just noted in the 3rd field "UnansweredQues1-21". Since multiple questions can be unanswered I copied the combo box several times in the form so I can choose different questions per each combo box and the problem I'm having is that when I select from the combo list a number from 1-21 all the other combo boxes automatically populate the same number. I want to be able to store mutiple unanswered questions in the "UnaansweredQues1-21" field, am I going into this the wrong way?

Answer 1

I'm not following your application here. if you want to record whihc questions were unanswered you should have a table with a record for each question.

Answer 2

Yes, you're going about this in the wrong way, in at least a couple of ways!

For one thing your table structure is wrong. It's a common error in questionnaire type applications; it's so tempting to have one field per question. But a normalized design uses three tables: a table of Questionnaires (with one record for each time someone answers the questionnaire); a table of Questions, with one record per question (21 questions in your case, until you decide to add two or three more questions); and a table of Answers, with one record for each time an individual question is answered.

The reason your combo boxes are not working as you expect is that they're either all bound to the same field (in the combo box's Control Source property) or they're unbound (nothing at all in the Control Source).