Problem using Duane's Survey Database - repost

[sara]

I posted this and got a suggestion that didn't work, so I'm trying
again.

I am trying to use Duane Hookum's survey database. I am still new at
all this, and doing ok, but having a problem.

When I open the form to enter survey results (frmSurveyResponses) and
click on "Enter Results", the subform displays, and shows the right
questions for the survey I am working on. BUT, the answer choices are
wrong. I get the same choices (Yes, No) in each combo box, even though
I have some questions with another possible answer, such as "N/A".

I see in Duane's code there is a Form! after Forms
collection!Formname!subformname!
and before the fieldname in the WHERE Clause. I am guessing this is to
somehow tell the subform to match the questionID, so it pulls the right
answer choices for the right question. I've never seen that before and
can't find posts on it. Maybe that is part of my problem somehow? I
do get the same syntax when I use the expression builder for what I
think is supposed to happen here, so I think the format is correct (and
it is what Duane has in his sample).

When I run just the subform and type in a QuestionID at the prompt, I
do get the right info. Just not when it's running in the actual survey
form. The form and subform are linked on ResponseID, as in Duane's
sample.

Basically I want to display a subform for the surveyID the user chose.
Each question listed in the subform, with a combo box of the answer
choices for each.

Here's the code for the combo box:

SELECT tblResponsesList.Response
FROM tblResponsesList
WHERE
(((tblResponsesList.QuestionID)=[Forms]![frmSurveyResponses]![sfrmResponses].[Form]![txtQuestionID]));

I'm tearing my hair out on this one...Please help!

Thank you !
sara

[salad]

sara wrote:

I posted this and got a suggestion that didn't work, so I'm trying
again.

I am trying to use Duane Hookum's survey database. I am still new at
all this, and doing ok, but having a problem.

When I open the form to enter survey results (frmSurveyResponses) and
click on "Enter Results", the subform displays, and shows the right
questions for the survey I am working on. BUT, the answer choices are
wrong. I get the same choices (Yes, No) in each combo box, even though
I have some questions with another possible answer, such as "N/A".

I see in Duane's code there is a Form! after Forms
collection!Formname!subformname!
and before the fieldname in the WHERE Clause. I am guessing this is to
somehow tell the subform to match the questionID, so it pulls the right
answer choices for the right question. I've never seen that before and
can't find posts on it. Maybe that is part of my problem somehow? I
do get the same syntax when I use the expression builder for what I
think is supposed to happen here, so I think the format is correct (and
it is what Duane has in his sample).

When I run just the subform and type in a QuestionID at the prompt, I
do get the right info. Just not when it's running in the actual survey
form. The form and subform are linked on ResponseID, as in Duane's
sample.

Basically I want to display a subform for the surveyID the user chose.
Each question listed in the subform, with a combo box of the answer
choices for each.

Here's the code for the combo box:

SELECT tblResponsesList.Response
FROM tblResponsesList
WHERE
(((tblResponsesList.QuestionID)=[Forms]![frmSurveyResponses]![sfrmResponses].[Form]![txtQuestionID]));

I'm tearing my hair out on this one...Please help!

Thank you !
sara

What happens if you enter
tblResponsesList.QuestionID = _
Forms!frmSurveyResponses!sfrmResponses!txtQuestion ID
(I put in the _ so it doesn't wordwrap)

Another way to reference a subform field is to use (). Ex:
Me("sfrmResponses")!txtQuestionID

[sara]

Same result. All answer options are Yes/No only.

Other thoughts?

Sara

[Bob Quintal]

"sara" <sa*******@yahoo.com> wrote in
news:11**********************@g10g2000cwb.googlegr oups.com:

I posted this and got a suggestion that didn't work, so I'm
trying again.

I am trying to use Duane Hookum's survey database. I am
still new at
all this, and doing ok, but having a problem.

When I open the form to enter survey results
(frmSurveyResponses) and click on "Enter Results", the subform
displays, and shows the right questions for the survey I am
working on. BUT, the answer choices are wrong. I get the
same choices (Yes, No) in each combo box, even though I have
some questions with another possible answer, such as "N/A".

I see in Duane's code there is a Form! after Forms
collection!Formname!subformname!
and before the fieldname in the WHERE Clause. I am guessing
this is to somehow tell the subform to match the questionID,
so it pulls the right answer choices for the right question.
I've never seen that before and can't find posts on it. Maybe
that is part of my problem somehow? I do get the same syntax
when I use the expression builder for what I think is supposed
to happen here, so I think the format is correct (and it is
what Duane has in his sample).

When I run just the subform and type in a QuestionID at the
prompt, I do get the right info. Just not when it's running
in the actual survey form. The form and subform are linked on
ResponseID, as in Duane's sample.

Basically I want to display a subform for the surveyID the
user chose.
Each question listed in the subform, with a combo box of the
answer choices for each.

Here's the code for the combo box:

SELECT tblResponsesList.Response
FROM tblResponsesList
WHERE
(((tblResponsesList.QuestionID)=[Forms]![frmSurveyResponses]! [s frmResponses].[Form]![txtQuestionID]));

I'm tearing my hair out on this one...Please help!

Thank you !
sara

Have you modified the subform to allow the third option?

--
Bob Quintal

PA is y I've altered my email address.

[sara]

I don't know what that means. If I open the subform by itself, and
enter in a question # when prompted, I get the proper answers for any
question # I type in. But, when it's in the actual form for entering
the survey results, I get only Yes/No - even the first question doesn't
show all 3 choices.

Does this help you help me?
This is very frustrating for me.

Thanks
Sara