Multiple Forms

[Stephen Hard]

I am developing a survey to be administered online. There are way too many controls to fit on a single form, so I created multiple forms each associated with part of the survey. The problem is that when I move from form to form the entered data is sent to a new record. How can I associate the forms to keep entering data into fields of the same record rather than moving to a new record?

Thanks for your help!

 

[WayneRyan]

Stephen,

If there are too many controls to fit on the screen, then your
table design is probably not efficient.

Here's a thread from this forum that might help:

http://www.access-programmers.co.uk...eadid=38435&highlight=survey+or+questionairre

Wayne

 

[Stephen Hard]

Wayne,

Thanks for the lead. I do not think there is much I can do about my table design. There is a field for the answer to every question. There are about sixty questions. Most of these require the selection of one out of five possible answers (a Likert scale). So I have sixty option groups each with five buttons. Then, of course, the forms also have all the labels that contain the wording for the questions. I investigated changing the form length without success. I am open to any suggestions.

Stephen

 

[JonatABS]

explain normalization

Alot of ppl on here use terms such as Normalization and alot of other terms that some people dont know.

WHAT on earth is Normalization.

 

[Stephen Hard]

Not only do I not know what "normalization" refers to, what is a ppl? Also, it seems to me that the type of table I need for my data entry requires a one to many relationship (each question [field] entering data into a large number of records). I do not understand how each question can be a record and still provide access to individual responses. Any help is appreciated. Thanks.

Stephen

 

[Stephen Hard]

Thanks Pat for the information. The first link is not working. The other two helped me to understand relational and flat file databases, but did not solve my problem. The problem I have is that every bit of data to be entered is unique. I could arbitrarily break the one table into several and then create links, but that sounds like more work rather than less. As far as the statistical analysis is concerned, I will not be using Access for that, but exporting the data to SPSS. This is very easy to do with a flat file architecture, another reason not to normalize the table. I chose Access for the projects I am currently working on because it enables me to create the user interface I need. Perhaps I should be using something else. All help is appreciated.

 

[Stephen Hard]

The corrected link was extremely helpful.