Questionnaire Problems Using Forms & Subforms

[Guest]

Hi

I'm a battling access user, trying to find solutions to ever increasing
problems. This one on the face of it looked simple, but I cannot get it to
work properly.

I have a questionnaire to fit into a database. The standard questions which
require the questionnee to select one of 2 or more single options is
starightforward enough, using look up tables.

The problems come with questions that have a series of answers, where the
questionnee can tick as many answers as they feel are applicable or the list
requires the questionnee to enter a number next to the answer.I.e how many
times?

I've tried using a subform but the subform only shows the empty datasheet
and i have to manually select each field in the subform to show the answer.

Baffling! Help would be much appreciated

 

[tina]

the problem is probably in your table design, not the subform design.
suggest you post your table setup, including table names, field names, which
fields are primary key fields, and how you have the tables related - so we
have something to go on.

 

[Guest]

Ok.. u are probably right.

The main Table is called tblStudent which holds all the questions in the
questionnaire except for those questions which require multiple answers.

Take one example question:

In what ways were you bullied?

option 1 to option 10 with checkboxes.

tblStudent has primary key of StudentID, and no corresponding field for this
question as the options are in the Bully table containing the options which
is called tblBullied, which has primary key of BulliedID, Option Name, and
Check Field.

When I link the bullied sub form to the student form to show the ten options
with a checkbox for each option and these ten options show up for every
record in student form, i get a subform with no options.

Does this assist any?



There are several examples of questions which require the questionee to
select as many of the options that are relevant or how many times each option
has occurred.

The

the problem is probably in your table design, not the subform design.
suggest you post your table setup, including table names, field names, which
fields are primary key fields, and how you have the tables related - so we
have something to go on.

 

[tina]

hmm, sounds like you've set up more of a "flat file" design, as opposed to a
relational design. having only created one survey database in the past
(which i wasn't too happy with), i'm not the best person to guide you on
fixing your table design.

i would recommend taking a look at Duane Hookum's database called
AtYourSurvey.mdb, to see how a survey/questionnaire database could be
correctly structured. unfortunately, i don't have a link to Duane's website,
or a copy of the database. suggest you post a request for the website link,
in a new thread.

hth

Ok.. u are probably right.

The main Table is called tblStudent which holds all the questions in the
questionnaire except for those questions which require multiple answers.

Take one example question:

In what ways were you bullied?

option 1 to option 10 with checkboxes.

tblStudent has primary key of StudentID, and no corresponding field for this
question as the options are in the Bully table containing the options which
is called tblBullied, which has primary key of BulliedID, Option Name, and
Check Field.

When I link the bullied sub form to the student form to show the ten options
with a checkbox for each option and these ten options show up for every
record in student form, i get a subform with no options.

Does this assist any?



There are several examples of questions which require the questionee to
select as many of the options that are relevant or how many times each option
has occurred.

The

 

[John Spencer (MVP)]

Duane Hookom has a sample survey database at
http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[tina]

great, John, thank you!

Duane Hookom has a sample survey database at
http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane