If Yes checked, display set of questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I saw an access database that had a very cool form. There were 5 Yes/No
options on the form. These were questions that applied to Quality Control.
When a box was checked to indicate yes, additional questions with Yes/No
options displayed below. Those questions that displayed asked questions
about that particular Quality Control Topic question. I'm stuggling to
figure out how that form was so interactive. Did each of the 5 questions
have it's own subform, or was it as basic as "if this box is checked then
display these questions". Any insight is appreciated. Thank you.
 
The typical way to do this is to hide the other controls, that is make the
visible property No in design view. Then use the After Update event of the
check box to make the visible again. Like:

With Me
.chkAnotherQuestion.Visible = .chkForMore
End With

You also need to reset it in the Form Current event for new or existing
records

With Me
If .NewRecord Then
.chkAnotherQuestion.Visible = False
Else
.chkAnotherQuestion.Visible = .chkForMore
End If
End With
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes/No fields and code to uncheck a default "yes" box if another yes box is checked 5
How Do I display a Yes/No Field correctly in a List Box? 2
Yes/No check boxes in Option Group 6
Displaying Yes/No as Yes or No instead of -1 and 0 2
Trigger event to set values in controls and disable them 3
Command button to put subform into "new record" mode? 3
Changing Yes/no box to combo box 2
Display Continuous Forms Side-by-Side 1

Back
Top