Create new records in form

[mem]

I am trying to get a survey database going. I have a table tblQstnnaires
that is the questionnaire name based on that I then have a table
tbl_Questions that list all the questions associated with the questionnaire.
I have a form that will open up the question form based on the questionnaire
that is selected. I then want to have a button that says take survey and
then open up a new form that will populate all the questions in the tblsurvey
so I can record the reponses by question.

I hope I was able to explain this.

Thanks.

QstnAires_ID QstnAire_Name First_Qst_Num
Qstn_Id QstnAire Qstn_Num Question Qstn_Type NextQstnNum
Response_id Qstn_ID Reponse User_ID Survey_Date

 

[John W. Vinson]

I am trying to get a survey database going. I have a table tblQstnnaires
that is the questionnaire name based on that I then have a table
tbl_Questions that list all the questions associated with the questionnaire.
I have a form that will open up the question form based on the questionnaire
that is selected. I then want to have a button that says take survey and
then open up a new form that will populate all the questions in the tblsurvey
so I can record the reponses by question.

Take a look at Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

or at

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb