question set should appear after a control is answered

G

Guest

I have a big question. I have created a form with several controls. There is
a control that has a "checkbox" option, and if the answered "yes" is chosen I
would like a set of questions to appear, and if the answer is "no" another
set of questions should appear. Now I have created a macro that does that,
but my supervisor doesn't want that option since once these sets of questions
are answered these new forms do not go automatically to the next record (each
set of questions are in different forms, I used the option in macro "open
form"). The reason is that people without much knowledge will be entering the
data, and I need to make things very simple. Is there a way(s) to make these
sets of questions appear everytime the control with the "checkbox" is
answered?
Miguel
 
G

Guest

If the extra questions to be displayed are in the same table, I would
recommend using the same form.
You can use the OnClick event of the check box to change the visible
controls, for example,

IF checkbox.value = yes THEN
TextBox1.Visible = True
TextBox2.Visible = True
TextBox3.Visible = False
TextBox4.Visible = False
ELSEIF checkbox.value = no THEN
TextBox1.Visible = False
TextBox2.Visible = False
TextBox3.Visible = True
TextBox4.Visible = True
ENDIF
 

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

Top