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