Access 2007: Conditional responses on a form

Posted on 2011-04-20
Last Modified: 2012-05-11
Hello, I want to make a database for a form that will have several questions of the type: 1a. Are you a smoker?  If yes please answer question 1b, else go to question 2."
Does anyone encounter such form questions and have a solution to how to go about doing this?  I could, and probably will unless I get some advice here, just make a table with fields associated with the questionnaire and let them leave them blank, but is there a programmatic way to guide the user to the correct question if they make the response?
I thought about using the visible fields properties to hide the question, and then use an on event macro to reveal it if the answer is yes for example.  But I'm not sure this would be a very good way to do this.

Does anyone have some thoughts?

Thanks so much,
Bevo S.
Question by:Bevos
    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    Depending on the number of variables, you could use a Tab control, and move the user to the relevant Tab Page based on their answers.
    LVL 47

    Accepted Solution

    Check out the "At Your Survey" database application.  

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    732 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

    17 Experts available now in Live!

    Get 1:1 Help Now