Query/Form question

[Guest]

Hello,

I have a table with questions, and I have a table with categories, so that
my questions can be sorted by category. A third table references the
questions via an ID field, and provides a field for a reply. This 3rd table
has the fields RespondentID, QuestionID, Answer. This setup lets me record
every respondent's answer to a multitude of questions.
My problem is in creating a form to input the data. For every category, I
need a separate form that lists all the questions in that category and
provides an opportunity to enter the reply.
I seem to be unable to create a query that lists the questions, however.
I suspect I'm approaching this the wrong way, but obviously I can't think of
the correct one.
Any help would be greatly appreciated.

 

[Jeff L]

If all you are trying to do is list your questions on a form, you
should be able to use your questions table as the Record Source for the
form.

 

[Guest]

Yes, that I can do. My troubles begin when I try to link the checkboxes for
the answers to the questions.

 

[Guest]

I think I figured it out.
Funny how asking a question sometimes helps come up with a solution.

Thanks Jeff for trying to help.

 

[Guest]

ur 2 kool