Help with jumping over sections of form

[robbie_1234]

Background: I have designed a form in Access 2010 (with your help) to compile survey responses. The form starts by identifying the respondents as: adult (assigned # 1); adult with comments (assigned # 11) and youth ( assigned # 2); youth with comments (assigned #22). If the box adult no comment is checked (# 1), certain portions of the form are not visible (comments section) and it allows me to jump from question to question without tabbing through the comments area. If youth (#2 or #22) is checked then an area of the form specifically for adults is invisible.

One of the last sections of the form requires a jump over a number of adult specific questions to the last area of the form; general comments. However, the form does not do the jump if the respondent is a youth but instead returns an error message.

How do I form the code for the last question that pertains to the youth and have it jump over the adult questions to the end of the form to the general comments area?

I have not worked on the database for some time but completed entering all of the surveys and noticed this problem. Can you help?
Thank you in advance

A novice Access user

 

[spikepl]

A form has in fact a method gotoPage (look it up) and you can insert pagemarks into the form. In this way, only one page of the form is displayed at a time, and you can have forward/back buttons to navigate the pages - or skip a page. Your "hidden" stuff could reside on a page that is skipped in the specific instance.

 

[robbie_1234]

I appreciate your help. However, none of the rest of this short form has page breaks. I am trying to do this by using an if then statement. i.e. if the value in section a is 1 or 11 then jump to x. if the value in section a is 2 or 22 then jump to y.

 

[spikepl]

I have no clue what "jump" is, or for that sake a "section". What is it? IF you mean that you have made a number of adjacent controls invisible and call that a "section" then this is exactly the type of things one can use a form page for.

What exactly is a "jump"?

 

[spikepl]

OP has seemingly abandoned this post and continues here: http://www.access-programmers.co.uk/forums/showthread.php?p=1161903#post1161903

 

[robbie_1234]

Thank you for your response.
I know I am not being very clear but I am not very familiar with the access 2010 database, VBA and form design (despite several classes).

The original survey was in response to a youth gathering. The paper/pencil form asked first if the respondent was a youth or adult. The form was then divided into sections evaluating various parts of the gathering: (speakers (11 of them); worship services (3); servant events (10 of them;, activities (4 different ones); mass gathering (3 questions) food (breakfast, lunch, dinner); housing (5 possible sites); overall organization of the gathering; overall grade of the gathering. The form then had an adults only area with several questions about registration, information table, meetings, etc. and then ended with a general comments section, name and congregation for adult and youth respondents.

I designed the access database form to "mimic" the paper/pencil form and assigned LIKERT values from 1-5 to each of the questions and then placed a comments section next to each question as many of the respondents penciled in comments for individual questions. I also assigned a "99" value if there was no answer and a "88" value if was evident the person did not participate in the specific event.

I was able to make the comments area of the form invisible if the respondent only checked the likert boxes (1-5) and did not write in comments. I was also able to make certain areas of the form invisible if the respondent was a youth rather than an adult.

Here is my current problem. If the respondent is a youth (1) or a youth with comments (11), even though the "adult only" questions are not visible, when I hit tab to exit the last youth question, I get an error message. Since the hitting tab does not take me to the next youth question, I have to manually move the cursor to the end of the form to the "general comments" questions to complete the particular survey. I was hoping to fix the error message.

Here is what I would like to do:
If the respondent was a youth with no comments, when "tabbing" to exit the last youth Likert question, the tab skip over the adult questions and land on the next youth questions, the "general comments area" rather than returning an error message.

If the respondent was a youth with comments, when tabbing to exit the last youth comment, the tab would skip over the adult questions and land on the next youth questions, the "general comments area" rather than returning an error message.

I hope I have been a bit more helpful


I can attach my database if you think it would help. Thanks