Questionnaire's - hiding questions

C

chris

I am trying to understand if it is possible to create a questionnaire where
questions are hidden until a certain answer is given.

E.g. Answer 'No' to question 1, then question 1b opens up that asks a
further question.

I presume some sort of macro would be needed for this? Any help much
appreciated.
 
D

Dian D. Chapman, MVP

Yes, it's POSSIBLE. But it'll depend on how to design up your template
as to how it would work. So providing a lot of details would be
difficult.

Example...first you would have a checkbox or dropdown for the
question. If the user clicks or chooses YES, then you could either
have text that has been hidden and you could unhide it. But since
users can set hide/unhide settings on their own, you'd have to also
control the dialog box for that option...which can be done, but is
complex if you're not good with VBA.

So an alternative would be to insert bookmarks in various locations
and then create more of the form as AutoText. When an answer is YES,
you'd move to the bookmarked location for that answer and insert the
autotext that contains the rest of the form. Of you could also use
separate doc files with the "parts" and insert those into the needed
bookmarks.

I'd suggest you start by checking some of my free AutoForm tutorials.
You'll find them here:
http://www.mousetrax.com/techpage.html#autoforms

You should probably start with the PLEASE FILL OUT THIS FORM series
(but skip # 5, that's advanced database connectivity).

But know that what you want to do will be a bit of a learning curve if
you don't know VBA.

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
 
G

Greg Maxey

Dian,

We are thinking along common lines wrt the AT. I posted a rather
lenghty potential solution to this same user (I think) and then another
much longer post discussion stumbling blocks that I did in fact stumble
over ;-).

Regardless of my bumbling, you are right. It is possible ;-)
 

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