Multiple choices

[vexatu]

Hi.

Problem 1:
I created an Option Group with 3 checkbox option buttons. Above those options is a question that can have multiple choices. For example for question: "How it is ?" The answering options are: "1) Big", "2) Red", "3) Tidy". I want to could check 2 and 3. Well the problem is that I can't check 2 boxes. It allows me only one checkbox. How could i do this. Each checkbox has set as Option Value: 1, 2 and 3, for each one. These values are stored in a table.

Problem 2:
Before I start the test, the user must complet a the form with his own unique CNP (Personal Numeric Code, from the Identity Card). The CNP could be choosed from a Combo Box (containing all CNP's from the tabel). Let's say that a new user play's the quiz, and he's not in the DB. When he press START test, I want first to verify if that CNP already exists (and if true play the quiz). If NOT exists, to run a form where he can register in the game with all his Personal Dates.

Problem 3: The quiz not accept "no answer" so before he click "Go to next question", a script must verify if he checked at least 1 (one) option from the Option Grup.

Could anyone help me at least with one problem? I'he already search and I found something about, but not exactly what I want, I tried to update it for me problem with no success.

 

[gemma-the-husky]

problem 1
a) either offer more choices in the option group or
b) dont put the chkboxes IN an option group
an option group WILL ONLY let you select 1 value

problem2
test it with a dlookup, and open the register from if necessary

problem3
a) unlock the next field, sequentially, after each one is answered or
b) test them all at the end or
c) try the lostfocus, or onexit event - you need one you can cancel - beforeupdate is no good if they dont respond

also
d) try listboxes instead of command buttons - slightly different presentation effect

 

[vexatu]

problem 1
a) either offer more choices in the option group or
b) dont put the chkboxes IN an option group
an option group WILL ONLY let you select 1 value

If I don't put the choices in the option group, then I must put them free in the form. So when I check an answer (let's say that I check answer number 3), it records the answer number with the value "-1" in the table tblTest, field Answered. That instead of 3, my answer ? Any idea ?

 

[gemma-the-husky]

you would have to set the values in the afterupdate events of the checkboxes. but you ave the same problem anyway, if you want to multiselect - you need some way of identifying the user selected optios 2 AND 4, dont you.

one way is to have a binary system

checkbox 1 is worth 1
checkbox 2 is worth 2
checkbox 3 is worth 4
checkbox 4 is worth 8

etc - the total of the checked, checkboxes is then unique - this is good for up to 15 check boxes, with a long variable