Form Design Help

[Lisa]

I need to create an input form that includes all the fields from TBL_1 (Eval)
and I need each question to appear (from TBL 3) with the fields from TBL 2
for each question.


How would I go about doing this so that the answer and comment for each
question will populate in a new row in TBL 2 which the Question_ID
relationship and the Eval_ID to connect the relationship to TBL 1?

TBL 1 (Eval) TBL 2 (Answer) TBL 3 (Question - there are 18
Questions)
Eval_ID Eval_ID Question_ID
Employee Question_ID Question
Mgr QuestionAnswer
Site QuestionComment
Date

 

[scubadiver]

If it is an evaluation survey you are doing I can help but it isn't easy.
You can download this one:

www.freewebs.com/davidbowman/db1.mdb

When you enter the subform it is meant to append the questions with the
respondent number but it doesn't quite work.

 

[Lisa]

I have used (for another form) this statement, but that was for one row..

strSQL = "INSERT INTO TBL_NBAnswer" _
& "(Eval_ID, QuestionAnswer, Q_ID, QComment) Values(" _
& "'" & Eval_ID & "'" _
& ", '" & q1Ans & "'" _
& ", '" & q1QuestionNo & "'" _
& ", '" & q1comment & "'" _
& ")"

 

[scubadiver]

Hello Lisa,

download this

www.freewebs.com/davidbowman/lisa.mdb

When you click in the subform, the questions will be appended with the
response and comments fields.

 

[Lisa]

Is there a way to have the questions there as soon as you enter a new form
instead of it populating once you have completed the date field?

 

[Lisa]

Also, is there a way to show the words to the question (which is the question
column) with the q ID???

Thanks for all your help.

This is great.

 

[scubadiver]

In "table3" there is a field called "question".

1) Enter the questions into the field for each Q_ID

2) Add this same field name into "table2"

3) Include this field in the subform. Create a new text field, go to the
"data" properties and select "question" as the record source.

4) In the append query drag the "question" field to the bottom pane.

Try it again and your questions will (or should) appear in the subform.


As far as your other question goes, I am not too sure because you need to
fill in the main form fields before you can be allowed to to append the
subform.