>I have a form that is used to enter responses from a
>survey that has 18 questions on it. In the table there is
>a question number field, response field, and a couple
>others. What I am trying to do is eliminate the need to
>type in the question # in the form by having the value
>starting with 1 and incrementing up to but not beyond 18
>and then resetting to 1 when a new survey is entered. I
>would also like to ensure that a value is entered in the
>reponse field for all questions before moving to the next
>record. Another thought was to have the question number
>field disabled or locked so the user not be able to change
>the 1-18 values to eliminate the possibility of
>duplicating a question number or skipping a question.
>Any suggestions?
>Thanks,
>Eric
Hi Eric,
One of the possible ways to setup the form you want is to create a combobox (with values between 1 and 18) for question number and provide command buttons "Next", "Prev", "First", "Last" to navigate between questions.
Just my 2 cents, Igor
Igor Gelin
Database Developer