On Tue, 20 Apr 2010 08:55:02 -0700, MsWatts
wrote:

Good Morning,

I am working on a Questionnaire Database. I'm currently trying to link
questions to specific subforms is this possible? If so, would someone please
help me with the code?

WHOA!!!!!

A separate *SUBFORM* for each question? That's really not generally a good
idea. A subform is a display tool; if you have variable data for each question
you would normally have one or more controls (textboxes, etc.) on a single
subform with varying contents, not a different form for each question.

If I was using the code below is there a way I could choose specific
questions like 1-30? Or would I need to create a table for each set of
questions?

SELECT DISTINCTROW tblQuestions.* FROM tblQuestions ORDER BY
tblQuestions.QuestionID, tblQuestions.QstnLvl;

Sure. Just put a criterion specifying which question or questions you want to
see.

You may want to look at Duane Hookom's excellent "At Your Survey" sample at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000'

or at

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/d...gistration.mdb
--

John W. Vinson [MVP]