Adding data to table

[Julian1234]

Hi, this is probably a very simple question but I would appreciate any help.

I have a form called Survey based on a table called question. What i need to do is - using the users reponse on the "Survey" form created new records in a table called "Awnser".

How do i do this?

Thanks

 

[Tiro Cupidus]

You can look up "Append Query" in the help file for some info. Or, if a little coding doesn't sound too bad, you could look up "SQL Statement" in the Answer Wizard. The "INSERT INTO" statement is one result that comes up.

 

[Jack Cowley]

tblParticipants
ParticipantID (PK and autonumber)
LastName
FirstName

tblQuestions
QuestionID (PK and autonumber)
Question

tblResponses
ResponseID (PKand autonumber)
ParticipantID (FK)
QuestionID (FK)
AnswerID (FK)

tblAnswers
AnswerID (PK and autonumber)
Answer

You do not need the Answer table if the possible answers for each question is the same, but you will need the Answer field in the Response table.

If tblResponses is a subform of tblQuestions then you table will be updated automatically.

hth,
Jack