Recurring Field in Access 2003?

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

Guest

I am trying to create a form in which a user will answer 200 questions.
I have created a table that has the columns: Question #, Question and
Answer. I will like to add a field to the form that identifies the
particular "engagement number" that the survey pertains to, but when I add
the field to my table and then create the form it requires the "engagement
number" to be filled out for each question - is there a way that the Name of
the individual and the engagement number only have to be entered once?
Thank you in advance for your time and consideration.
 
I am trying to create a form in which a user will answer 200
questions. I have created a table that has the columns: Question #,
Question and Answer. I will like to add a field to the form that
identifies the particular "engagement number" that the survey
pertains to, but when I add the field to my table and then create
the form it requires the "engagement number" to be filled out for
each question - is there a way that the Name of the individual and
the engagement number only have to be entered once? Thank you in
advance for your time and consideration.
Click to expand...

sure,and a very easy one

create a user table (user ID, user name and so on) and use it to create
a new form with the required user fields

add a linked user ID field in the Q&A table and enforce the related
fields
then make the Q&A form a subform of that user info form

this way you have a linked table with user info and all answers
answered by that user have the user link value automatically entered

grtz
 
Back
Top