Re: Survey Design

On Thu, 14 Feb 2008 06:48:53 -0800 (PST), "weircolin@xxxxxxxxxxxxxx"
<weircolin@xxxxxxxxxxxxxx> wrote:

Hi There

I am creating a survey in access for children with disabilities.

Not all the questions will fit on the one form, is there a way that I
can have a "next" button to open the next set of questions and close
the current ones being displayed?

Thinking that button would just have two functions, open the next form
and close the current, and would that be seemless?

Cheers

It sounds like you've fallen into the very common "every question as its own
field" trap. This is tempting but is in fact a bad design for surveys!

Instead, you should consider designing your tables so that every question is
stored in a diffrent *RECORD* of a questions table, and similarly for answers.
For an excellent worked out example see Duane Hookum's excellent sample:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%202000'

--
John W. Vinson [MVP]
.