Dynamically Build Survey Data Entry Form

Posted on 2006-03-20
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

    in case you are interested: 3rd party survey creation software that uses Access and/or Outlook

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now