I think that's why the QstnLvl is there. You could set a value in the main
form for the QstnLvl and use the Link Master/Child properties to display
questions based on the level. If you can't use this field, you might need to
add another method for grouping similar questions.

--
Duane Hookom
Microsoft Access MVP


"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?

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;

Thanks for the help
~Tammy