Dynamically Build Survey Data Entry Form

Posted on 2006-03-20
Medium Priority
Last Modified: 2008-03-06
I have a survey project where there are several categories that may have any mumber of questions per category.

All the questions are entered in a table named tblQuestions,which has a CategoryID field in it....

I'd like to dynamically build a data entry form based on the questions entered for each category.

For Example - category 1 may have 3 questions - and category 2 may have 5 questions, etc....

The issue is, that there may be 10 or 12 categories, with different numbers of questions in each....

sample data below......

Category1 (SALES) - CategoryID= 1

Question 1
Answer A.  B.  C.

Question 2
Answer A.  B.  C.

Question 3
Answer A.  B.  C.

Category 2 - (MARKETING) CategoryID = 2

Question 1
Answer A.  B.  C.

Question 2
Answer A.  B.  C.

Question 3
Answer A.  B.  C.

Question 4
Answer A.  B.  C.

Question 5
Answer A.  B.  C.

Category 3 - (ADVERTISING) CategoryID = 3

... may have any number of ?s entered

Question by:abinboston
1 Comment
LVL 38

Accepted Solution

puppydogbuddy earned 750 total points
ID: 16244287
in case you are interested: 3rd party survey creation software that uses Access and/or Outlook       http://www.mapilab.com/outlook/easy_survey/

Still want to develop your own?  This link contains a step by step tutorial for building a simple survey db using a survey on ms access to illustrate
Hope this helps.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question