Form Design Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 & "'" _
& ")"
 
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?
 
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.
 
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.
 
Back
Top