I'm currently working on a questionnaire project. I'm trying to work out the ability to have a combo box filled with responses that are dynamic to the question being asked. Basically, some questions are as simple as Yes, No, or NA, and some have more specific responses needed. I'm trying to avoid writing the questions so that everything can just be answered as Yes, No, NA, which will make the questionnaire more effective.

Currently the questions are in one table, the list of questions is dynamically generated through the use of a Questionnaire to Questions Junction. I also have a Responses Table, and a Junction table tying a subset of potential responses to the questions.

I can't seem to be able to get the response combo box to link to the loaded question (the questions are presented in a list, using essentially the multiple items layout, instead of one at a time -- which is a requirement).

Any thoughts?