I am making a survey, using Access 2007, that will be self-administered by participants in a study.
The user moves through the survey as though it was a web survey. Each page is a new form (so the sequence would be Form 1 to Form 2 to Form 3 to Form 4, etc). All data collected from the various forms is saved in one table.
The problem I'm having, however, is that the data collected from the different forms seem to be saved in different records. For example, data from Form 1 will be saved in the table as Record 1. As the user progresses through the survey, data from Form 2 and Form 3 are saved as Record 2. For the rest of the survey, data is back being stored as Record 1.
If I try to open a new record, it will do so for Form 1, but the data that had been previously entered into Form 2 will remain. Is there a way I can open a new record that will carry through for each form?
I hope this makes sense. Thank you!
The user moves through the survey as though it was a web survey. Each page is a new form (so the sequence would be Form 1 to Form 2 to Form 3 to Form 4, etc). All data collected from the various forms is saved in one table.
The problem I'm having, however, is that the data collected from the different forms seem to be saved in different records. For example, data from Form 1 will be saved in the table as Record 1. As the user progresses through the survey, data from Form 2 and Form 3 are saved as Record 2. For the rest of the survey, data is back being stored as Record 1.
If I try to open a new record, it will do so for Form 1, but the data that had been previously entered into Form 2 will remain. Is there a way I can open a new record that will carry through for each form?
I hope this makes sense. Thank you!