Forms - Splitting Questions & Design

[robertmeyer1]

Hi,

I have 3 tables set up. tblQuestion, tblAnswer, tblClient. I have them linked together and have a sbf and mainform set up for data entry. The sbf links the questions and answers together. The mainform is based off the tblClients and has the sbf inserted into it. At this point, all the questions from tblQuestions are shown, and tblAnswers have $0.00 (currency fill-in field). SO the questions are all prepopulated with the default answers. What I need to do is split this form up. I have about 200 questions, which is more than I want on the form. I want to make about 5 forms, each with about 40 questions. This will make it easier for question grouping and for data entry. How can I set the properties to display only certain questions on each form? (ex: Form A displays questionNo 1-40; Form B displays questionNo 41-80).

Some background: tblQuestions has 200 questions. This table has a QuestionNo (autonumber 1-200) and a text field “Question” which has all 200 questions entered. tblAnswers is based off a query which combines the questions with the “default” answers ($0.00). TblAnswers has a ClientID FK in it. And on the mainform, this is set to equal the mainforms ClientID (based off tblClient).

So in summary. I have all the questions and default answers displayed for a Client at the moment. But I need to split the questions up onto multiple forms. (Special thanks to mmccarthy for getting me to the point where I can ask this question). Thanks.

[robertmeyer1]

This thread is closed. It was recomended I create quereis based off my single 1 and insert the parameters.