Unanswered: Query design and filling comboboxes with values
option_ID (this is the chosen option)
TBLOPTIONS (displays the possible answer options per question)
I want to show a continuous form with all my questions (i.e. one question per form detail), and the user must be able to see/enter/change the answer for a specific checklist.
So, the datasource for my form is a query:
SELECT tblchecklists.checklist_ID, tblanswers.question_ID as question_ID, tblanswers.option_ID,tblquestions.label from tblquestions inner join (tblchecklists inner join tblanswers on tblchecklists.checklist_ID=tblanswers.checklist_ID ) on tblquestions.question_ID = tblanswers.question_ID
This query works, and gives me for a specific checklist all the questions ANSWERED. This means, if there is not yet an answer object for a specific question, the question will not be displayed. Off course, I want all the questions displayed because I want the user the answer them. How can I alter my query to do this is or there a better way to accomplish this?
I have for each question a label, and a combobox with the possible options listed. The label can be taken directly from the query, but for the combobox, I use this procedure:
cmboptions.rowsource="SELECT label from tbloptions where question_ID=" & me.question_ID
Alas, it doesn't work. Where do I have to put this procedure (which event), or is there a better way to look up the possible values for each question and put them in this combo?