Survey Design

[weircolin]

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

 

[Al Campagna]

If you had 10 questions, you could create an individual form for the
first 5 (ex. frmQ1ToQ5)... and another individual form frmQ6ToQ10 for the
remainder.
Given a button named cmdQ6ToQ10 with a caption of NEXT... use the Click
event to...

Private Sub cmdQ6ToQ10_Click()
DoCmd.OpenForm "frmQ6ToQ10"
DoCmd.OpenForm "frmQ1ToQ5"
End Sub

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John W. Vinson]

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 Your Survey 2000'