>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


you could be nice to your users and implement something of a wizard,
that would 1) let them back up to previous questions and 2) enclose
the whole thing in a BEGIN TRANSACTION - END TRANSACTION / ROLLBACK
bracket. in your navigation buttons (NEXT & BACK) you have control
over the question #. in the FINISH or QUIT buttons, you have control
over the END TRANSACTION / ROLLBACK choice.