MS Access form with multiple records per page

Hi,

I need to design a form looking like an evaluation sheet with about 20 questions and possible answers to them. A user would have to select answers according to questions.

Questions need to be pulled from a table called "tblQuestion" and inserted all at once in the same page of a form. Answers are taken from a "tblAnswer" table as a combo boxes beside each question. Results of this form would go to a 3rd table called "tblResult".

I was playing with the forms and couldn't get further than placing a single combination of question-answer on that form. Could anybody give me a hint on how on one form I could have multiple question-answer combination which would insert multiple records in the "tblResult" table.

I'm a beginner in Access and don't know any VB coding or Macros.

Thanks in advance.

In case you need to see the tables' structures:

tblQuestion: (ID | Category_ID | Question)
tblAnswer: (ID | Response)
tblResult: (ID | Question_ID | Response_ID | CLASS_ID)

RaO,

I would look into "Option Groups" for each question. Each Group would have it's own set of option buttons you could set as the answers to the question. This way choosing one answer over another will move the selection fill to that answer and remove it from it's predecessor.

Unfortuntely this is VB and needs further investigation and I don't have anything else on hand. Look into VB forums on Option Groups.

Sorry that's all I have.