MultiSelect List Box or any other way?

[paulcliman]

I think most of my Questionnaire problems are solved; however.......
there are a couple of questions of this type:

"Does your child read?" "(i)with interest in illustrations
(ii)favourite books (iii)handling books with care, correct way up and
turns pages (iv)talking freely about the characters"

Each or any of these may be chosen and need to be added to a running
total of scores i.e. a total of between 0 and 4 would be possible from
this one question.

How is this best done? I know I can set up a listbox with multiple
selection,, but how? and how do I score it? Also, if "reading" is a
lookup table with the above 4 records, how could it possibly store more
than 1 choice?
You can guess, can't you.......I'm confused!
I know I could set up, for example, 4 fields in the main "children"
table e.g. reading1, reading2 etc and have them as "yes/no" types but
is there a shrter and slicker way of doing this?
TIA
Paul Climance

 

[The Sisko]

Howabout a layout as follows:

Question A1 RB1 A2 RB2 A3 RB3 A4 RB4 Question Total Score

where A1-A4 are the 4 possible answers and RB1-RB4 are 4 radio buttons
This would allow you to select all or none of the 4 possible answers
When you move onto the next Question a bit of code would calculate an
populate the "Question Total Score" field for the previous question.

I think this is better looking and more presentable than a list box a
you can clearly see what has been selected.

PaulC

 

[Douglas J. Steele]

Except that's a misuse of radio buttons, as they're supposed to be used.

Radio buttons are intended to be used when only one value can be chosen from
a number of choices. To allow multiple selections, you should use check
boxes.