Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with incrementing number
Message
 
To
23/07/2001 10:41:52
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00533914
Message ID:
00535411
Views:
13
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform