Access 2003 Form Question

[Jeff]

I have an access database that I am using for site surveys. In a nutshell,
there is a header table with a date and location as the keys and a detail
section with the survey results. The detail section shows a series of 30 or
so questions(from a questions table) on how the site was rated. I am trying
to design a form that populates a yes/no/not available type response in the
detail section. The user would either click on a yes/no/NA type box or
have a drop down and select the value(whichever is easiest) next to the box.
After the user answers the 30 or so questions, an answers table needs to be
populated depending on how the questions were answered.

Here is an example of what I want.

______________________________________________________________________
Header

Site ----- Date-----

______________________________________________________________________

Detail
Question 1 -------- Yes
Question 2 -------- No
Question 3 -------- No
.......
Question 30 ----- NA

_______________________________________________________________________

My problem is how exactly this form should be designed and how the answers
can get updated into my answers table when the user is finished.

Any help or suggestions are appreciated.

 

[Douglas J. Steele]

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