Hi -
I have been trying (for 2 days now) to make some simple surveys (5-7
questions each, each with 2-3 answer choices, always from the list)
using Duane's sample. I've searched and searched posts and all point
to Duane's sample, but I'm just not getting it! Close, but no cigar.
I am a newbie, and the app isn't documented, so I'm stuck in a few
places. Right now I want to see my survey (frmSurveyResponses). I
have all the data loaded, but when I choose my survey, I get all the
questions in sfrmResponses, but the responses aren't right for the
question. I basically get the same responses (Yes, No) for each
question, even though question #4 may have N/A as a possible response.
Can someone help?
Here is the RecordSource for the Main Form: (frmSurveyResponses - it
works)
SELECT [tblSrvRspns].[SurveyID], [tblSrvRspns].[ResponseID],
[tblSurveys].[SurveyName], [tblSrvRspns].[EEFirstName],
[tblSrvRspns].[EELastName], [tblSrvRspns].[LocationKey],
[tblSrvRspns].[Comments], [tblSrvRspns].[Notes] FROM tblSurveys INNER
JOIN tblSrvRspns ON [tblSurveys].[SurveyID]=[tblSrvRspns].[SurveyID];
RecordSource for the subform (sfrmResponses - doesn't work: Linked on
ResponseID in both master and child)
SELECT DISTINCTROW tblResponses.*, [tblQuestions].[QuestionText],
[tblQuestions].[QuestionLevel1] FROM tblQuestions LEFT JOIN
tblResponses ON [tblQuestions].[QuestionID]=[tblResponses].[QuestionID]
ORDER BY [tblQuestions].[QuestionLevel1];
RecordSource for the combo box that should hold the various responses:
SELECT [tblResponsesList].[Response] FROM tblResponsesList WHERE
((([tblResponsesList].[QuestionID])=[Forms]![frmSurveyResponses]![sfrmResponses].Form!txtQuestionID));
I'm not using many of the features Duane created (level2 level3, etc.
Just not needed).
QuestionID and ResponseID are hidden fields on the subform.
I am stumped - Truly appreciate some help here!
Many thanks in advance -
Sara