Multiple forms problem

[Poooominator]

Hello

Can anyone help with this, or point me in the direction of a thread that may help?

I am trying to use Access as an online questionnaire. I have tables as follows:

tblCourse
CourseLeader (PK)
CourseTutor
Course
Course number
etc

tblQuestionnaire
QuestionID (PK)
QuestionNumber
Question

tblResponse
ResponseID (PK)
QuestionID
CourseLeader
Response

There are 44 questions, written out in the datasheet view of tblQuestionnaire.

The 44 questions are grouped into 10 different categories. The problem I have is that I want forms in which course leaders can enter responses (then produce a report with all of the responses printed), but at the moment I either get 44 different pages, or a continuous sheet with 44 sections. Is there any way of having a separate form for each category of question (e.g. a form for questions about assessment methods, then a form for questions about student support)?

 

[goldenvision]

(1) Create a form bound to your questions table.

(2) Bind text boxes to only the questions you require for a category

(3) Repeate steps 1 and 2 until you have all of your categories

(4) Create either a form with subforms or a form with tab sheets

That should do it

 

[Poooominator]

Thanks very much - I'll have a go - watch this space though

 

[Poooominator]

re No 2 - How do I bind text boxes to only the questions I require for a category? It is bound to the questions field, but I am still left with 44 separate pages or 44 sections in a continuous sheet. Sorry to be so thick - but I'm quite new to this

 

[goldenvision]

Can you zip and attach your database.

It is probably easier to show you than explain

 

[Poooominator]

Ok Cheers - I'll have to do it from home this evening - thanks for the offer of help.

 

[goldenvision]

I'm going to be away from my PC for 5 days after today so I'll do you an example of what I mean and post it here

 

[Poooominator]

Thanks - if anyone else has any ideas I'd be glad to hear them