HLP! Y/N with other Input Options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been struggling through my questionnaire database, taking AYS and
trying to customize it for my use.

Here is the problem: I have multiple answers for each question, but it's
not a simple limit to list, choose one, or type your own text. It may be
many selections from the list, plus comments. AYS seems to work very well
for combo box - select one or type one - 1 qstn = 1 answer. In my case, this
doesn't work.

Duane had suggested that rework it so that my list of answers are actually
reworded to be my questions, which I have done, so now instead of, say 50
questions, I have more like 250 questions, using the true original questions
as main headings. That has worked fine. For example:

QnaireID
SectionName
QstnMainHeading - What languages do you speak?
QstnNo (as on hard copy qstnaires) A01 - English
A01 - French
A01 - German
A01 - Other (specify)

I have the RspnsType column in thie table where I can specify whether the
answer should be 1- logical, 10 - text, 7 - numeric, etc.

Here is my problem:

In my tblAnswers I have no idea how to achieve having a Y/N answer for most
questions, but a text answer for some, or a number for others.

On my form, I would like to select the questionnaire, which works fine as
per AYS, but on the subform, I want to show:

Section QstNo Main Question Question Text (locked and disabled), then
either a check box where I can just select a Y/N response for each question
which is logical, or a text box, where I can input other text or numerical
answers.

I have searched the newsgroups and looked on the Internet, in addition to
reading and working on this for hours and hours and am at a loss.

I would really appreciate any help possible.

Thanks so much
 
Note: I had put check box in what I would like to display on the form, which
is incorrect. It's either Yes or No, so I would want radio buttons:

Question Y N
Other
Do you speak English? o o
Do you speak French? o o
What other language do you speak? Text box here

Thanks!
 
As per AYS, a Yes/No question creates a selection combo box of Yes or No. I
don't believe you can display check boxes and combo boxes and text boxes in a
continuous subform.

As an option, you could add a field to your table of questions that would
trigger opening a dialog form with a single question and any format/controls
you want.
 
Hi Duane,

Hope you caught some big ones on your trip!

I am interested in your idea of adding a field to the table of questions to
trigger opening a dialog form. Could you expand upon this idea?

This database has turned into a nightmare - so many variables - surveys that
are already hard copy, so no option of reorganizing the way data is gathered.

Enough to make me want to jump off the nearest bridge!

Thanks for your help, as always. I truly appreciate it.
 
You could have a dialog form that would display a single question with for
instance a checkbox to take the response. Your Question table could have a
numeric field that would be read in the On Current event of the subform (or
possibly other event). If the value of the field is 0, the standard combo box
would be used. If the value of the field was 1, the dialog form would open
with the current question.
 
Back
Top