How to work with 'multiple response sets' in Access

[Wim]

Hi Tina, thanks once again for your help.
I downloaded, renamed and opened the file without any problem.
However, your solution, using a subform in datasheet view, is not what I was
having in mind. Sorry. What I would like to have is 60 checkboxes together
with their labels on a form just as they would appear if they were linked to
individual fields in a (spreadsheet style) table. On clicking on the
checkboxes, the answers would get stored in the underlying, normalized table
(i.e., in an intersection table containing the respondent number and the
question number as foreign keys - I am assuming here we work with only one
survey and that all questions are boolean yes/no data type).
Can this be done? Maybe only by using VBA?

 

[tina]

i'm way too lazy to do it

programmatically unless i absolutely have to!

this doesn't fall into the category of "absolutely have to" for me, so
sorry, hon, you're on your own. maybe somebody else will help. if you don't
get a response in this thread in a day's time, suggest you repost - with
specifics from this thread that will bring folks up to speed on where you
are now. you can include a link to this thread, but i don't recommend that
you count on people being willing to read this entire thread in order to
help you. good luck with your project.

hth

 

[Wim]

OK, fair enough! You have been of great help anyway.
I'll just wait if Pat still has something to say on this topic. If not, I'll
follow your suggestion. Cheers!

 

[Pat Hartman \(MVP\)]

If you want your Access application to look like a spreadsheet, you'll need
to pay the price. And that price is lots of VBA code because you'll need to
use unbound forms. I don't have an example to give you. I have always been
able to convince clients that the cost and limitations of making Access work
like Excel are not worth the benefit (no change to their existing
interface). If they really want Excel interfaces, they should stick with
Excel. As Tina said - good luck with this project.

 

[Wim]

Pat, I am sorry, but I disagree with you. I am not trying to make Access work
as if it were Excel, I am just trying to make things easier for the user.
Let’s forget the survey and think of a different example. An insurance
company wants applicants for a health insurance to fill out a form on which,
among other things, they ask “from which of the following diseases have you
sufferedâ€; follows a list of 60 diseases. The easiest solution for the user
would be to have 60 check boxes to choose from. A combo box or a list box of
60 diseases is just not practical. What happens behind the screen, how Access
stores the information, should not be the user’s problem.
What I really want is an option group, but is should be a “multi-option
option groupâ€. That doesn’t sound too far-fetched to me!
Anyway, I started a new thread in the Access Forms discussion group
(http://www.microsoft.com/office/com...ms&mid=17058c8f-f729-465c-8d48-cd06d1899b68);
let’s hope I get some fresh answers there.
Thanks for your help.