MS Access 2013 Forms: Skipping questions on a form

[7HikingLeo]

I have created a main form with tabbed subforms. I need to do one last subform (see attached screenshot). If someone selects the Observation check box I want them to answer the Observation question and then skip to the last 3 questions. If they select the Education check box I want them to answer the 2 Education questions then skip to the last 3 questions, etc. I'm new to making forms, however I did get the feel for doing After Update Events and a couple of other code building functions, but I'm stumped on how to go about coding this last subform.

[June7]

One option is to set the textboxes as not visible in the form design then in code set the appropriate controls visible depending on which checkbox is selected.

Another is to use a tab control and put each category on its own page of the tab control. Then user just needs to click the appropriate page instead of clicking a checkbox. Or you can still have the check boxes (see comment below) on the form and code would set focus to appropriate tab control page.


Also, probably should use radio buttons in an option group so that only one can be selected, assuming the 3 categories are mutually exclusive.

[HiTechCoach]

I like to use June7's alternate solution. II call it a Wizard style form.

I have an example templateyou can use. Check out:
Wizard Form template

Hope this helps.

[7HikingLeo]

I created the option group with the 3 selections (Observation, Education, Research). I've made the textboxes invisible. As for: "in code set the appropriate controls visible depending on which checkbox is selected"; I've been unsuccessful. I've been searching and watching YouTube on how to do it, but I'm just not experienced in writing code.

[aytee111]

With Option Group there are values for each selection, starting with 1. In the OnClick event of the frame control, add the code to make the questions visible or invisible.
If FrameFieldName=1 Then
(observation fields visible, all others invisible)
ElseIf FrameFieldName=2 Then
...

[June7]

The If Then Else structure would require referencing each textbox control in each condition to set Visibility to true or false. That means referencing each textbox 3 times.

Alternative code:

Me.textboxname.Visible = Me.framename = x

Use the actual control names and the appropriate value for x. This will set each textbox Visible property to true or false without an If Then Else structure and each textbox is referenced only once although the framename is referenced multiple times. Or set a variable with value of frame and use the variable in each expression.

intCat = Me.framename
Me.textboxname.Visible = intCat = x

Just a matter of preference, pick whichever method you like.

[7HikingLeo]

Thanks you two SO MUCH! You saved me so much time. Wish I had tried this forum a month ago.

I tried both ways suggested and they both worked. Here is what ended up using (so darn simple if you know what you're doing):

Private Sub ProjectUseOptions_Click()
Me.Observation_Measurements.Visible = Me.ProjectUseOptions = 1
Me.Education_Activities.Visible = Me.ProjectUseOptions = 2
Me.Education_NOofVisitors.Visible = Me.ProjectUseOptions = 2
Me.Research_GPScoordinates.Visible = Me.ProjectUseOptions = 3
Me.Research_Instrumentation.Visible = Me.ProjectUseOptions = 3
Me.Research_RNAUniqueness.Visible = Me.ProjectUseOptions = 3
End Sub