Stuck with Duane's sample Survey Database

[sara]

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 (frmSurveyRespo nses). 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: (frmSurveyRespo nses - 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 [tblResponsesLis t].[Response] FROM tblResponsesLis t WHERE
((([tblResponsesLis t].[QuestionID])=[Forms]![frmSurveyRespon ses]![sfrmResponses].Form!txtQuesti onID));


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

[pietlinden@hotmail.com]

Re: Stuck with Duane's sample Survey Database

sounds like there's no join between your question table and answer
table. go to tools relationships and make sure there's a relaitonship
defined between the two.tables (whatever they're called - surveys and
results or whatever.

[sara]

Re: Stuck with Duane's sample Survey Database

There were relationships, and I checked them to make sure they were
right. Still nothing.

What I am trying to do is have a drop-down with all the possible answer
choices for each question. I am guessing it has something to do with
the last Form! in
])=[Forms]![frmSurveyRespon ses]![sfrmResponses].Form!txtQuesti onID));


Help!!!

Thanks
sara