[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

Access 2007: Conditional responses on a form

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.
2 Solutions
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
Dale FyeCommented:
Check out the "At Your Survey" database application.  

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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