Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

Best way to deal with multiple questionnaire types

I'm just looking for advice.  I am creating a database for the purpose of an interview process.  Questions and answers.

But depending on the individual filling out the questionnaire different sub-forms need to be presented.  There will be one main form for general questions and answers.  But then depending on the type of application being filled out, different sub-forms need to be opened on the main form.

Is there a way via VBA code to do this or do I need several main forms with their respective sub-forms designed into them?

If different sub-forms can be presented to the user what type of code needs to be included in the main form to make them open?

--Steve
0
SteveL13
Asked:
SteveL13
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
see this for a starter  http://support.microsoft.com/kb/292299
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can modify the SourceObject value of your SubForm control to show a specific Form in your Subform control:

me.YourSubformControl.SourceObject = "Form1"
0
 
PatHartmanCommented:
I don't have enough information to define specific tables for you but the following should get you going.
tblQuestionnaireType
QuestionnaireTypeID (autonumber, PK)
Description
...
tblQuestions
QuestionID (autonumber, PK)
QuestionText
...
tblQuestionnaireQuestions
QQID (autonumber, PK)
QuestionSeq (used to order the question on the report or form)
QuestionnaireID (FK to tblQuestionnaire)
QuestionID (FK to tblQuestions
...
tblPerson
PersonID (autonumber, PK)
FirstName
LastName
....
tblPersonAnswers
AnswerID (autonumber, PK)
PersonID
QQID (FK to tblQuestionnaireQuestions)
Answer

This model allows a specific question to be used in multiple questionnaires.  When the questionnaire starts, your app decides what questionnaire will be used and then copies the QQID's from tblQuestionnaireQuestions for the chosen QuestionnaireID and appends them to tblPersonAnswers  with the PersonID of the person answering the questions.

There are lots of other options if you are using multiple choice questions or even a variety but this sounds like text answers so I didn't go into that.
0
 
SteveL13Author Commented:
All great advice.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now