Arranging a dependent field in a form

[Bradex]

I have a list of questions and sub-questions in a form.

e.g. Are you above 40 years of age? Yes/No
If the answer for this is yes, then another sub-question has to be answered. If the answer is no, this sub-question need not be answered.

I have arranged all of them (both the question and sub-question) in a tabular format.
But it is a bit confusing for the user, as questions which have to be answered and which may have to be skipped occur sequentially.



What is the best way to display them in a form.

The options seem to be:
1) Remove them from the tabular layout and manually and keep the sub-question below the main question just like a indented bullet list.
2) Make the sub-question appear in the form only if the main question is answered yes. Is it possible?

Please advise me if a better method is available.

[alansidman]

I would opt for number 2 and use the after update event to disclose the sub question. Set all sub questions to hidden in the On load event for the form.

[Bradex]

Can you please share the code for hiding the sub-question controls here. Thanks!

[Bradex]

I tried this, but it did not work:

Private Sub Form_Current()
If Me!ComboBox.1 = "Yes" Then
Me!ComboBox2.Visible = True
Else
Me!ComboBox2.Visible = False
End If


End Sub

[Bradex]

Tried the above code after replacing the first line with:

 Private Sub ComboBox.1_AfterUpdate()

Still not working.

[Bradex]

I found a decent workaround for this!

First disable the sub-question control. Then, use 'Conditional formatting' to enable it if the answer to the main question is "Yes".

[alansidman]

Glad you got it working.

[Bradex]

Thanks for your guidance!