I have a survey database (please view attached Relationships) that I have been struggling with for quite awhile. The problem is in the data-entry form. This form consists of:
frmSurvey, which contains demographic data about the surveyee (which clinic they are in, etc.) and generates a number, CompletedSurveyID. It has two subforms (frmActiveSurvey and frmActiveAnswer).
ActiveSurvey is not linked to the original form (frmSurvey), but allows selection of a survey via a combobox. Upon selection, the survey opens a sub-subform (to frmSurvey) named ActiveQuestion that displays the current question. It is linked to ActiveSurvey by SurveyID via a query that searches for all the questions associated with the survey selected.
Sub-subformActiveQuestion is advanced to the next question by a "Next Question" button
ActiveAnswer is linked to the original form (frmSurvey) by a field called "CompletedSurveyID". It has a combo-box that allows selection of an answer to the question and saves it.
The problem I have is that
1. I cannot figure out how to get ActiveAnswer to update the combo box when the "Next Question" button is pushed. I also have to have a "Next Answer" button on the ActiveAnswer subform, necessitating 2 button clicks.
2. I can only get the answers in the Combobox to update on the second click of the box, (after Next Answer). I had to use the "Before Insert" option, as that was the only one that would work.
Any thoughts here. The problem is simple. TOO MUCH CLICKING! I am hoping that the answer will be similarly simple. One can always hope!
Thanks for your consideration!
frmSurvey, which contains demographic data about the surveyee (which clinic they are in, etc.) and generates a number, CompletedSurveyID. It has two subforms (frmActiveSurvey and frmActiveAnswer).
ActiveSurvey is not linked to the original form (frmSurvey), but allows selection of a survey via a combobox. Upon selection, the survey opens a sub-subform (to frmSurvey) named ActiveQuestion that displays the current question. It is linked to ActiveSurvey by SurveyID via a query that searches for all the questions associated with the survey selected.
Sub-subformActiveQuestion is advanced to the next question by a "Next Question" button
ActiveAnswer is linked to the original form (frmSurvey) by a field called "CompletedSurveyID". It has a combo-box that allows selection of an answer to the question and saves it.
The problem I have is that
1. I cannot figure out how to get ActiveAnswer to update the combo box when the "Next Question" button is pushed. I also have to have a "Next Answer" button on the ActiveAnswer subform, necessitating 2 button clicks.
2. I can only get the answers in the Combobox to update on the second click of the box, (after Next Answer). I had to use the "Before Insert" option, as that was the only one that would work.
Any thoughts here. The problem is simple. TOO MUCH CLICKING! I am hoping that the answer will be similarly simple. One can always hope!
Thanks for your consideration!
