Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with incrementing number
Message
 
À
23/07/2001 10:41:52
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00533914
Message ID:
00535411
Vues:
14
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform