Questionnaire - Confused and stuck

[pdmax]

Hello everyone, I have a query that I thought I could get you help with.



I am conducting a questionnaire that involves 250 people. Tables have been created within Access, where each table relates to a section of the questionnaire. 8 sections gives me 8 tables. For each table there is a respective form to be filled in.

In the first form, users enter personal details such as name etc, and then are presumably given unique IDs. What I am stuck with is getting these unique IDs to then automatically transfer to the next form (i.e. the next section in the quesitonnaire) without the user having to enter it in manually.

Does this make any sense? Is more clarification needed?

Many thanks

pd

[Amicron]

If all you're gathering are NAME/VALUE responses, you might be better off just using ONE table for ALL of their responses.

TABLE: ResponseT
ID, Autonumber
PersonID, LongInt (the ID for the respondent)
QuestionID, LongInt (link to the question in the question table)
Answer, Text (their actual answer)

Now in your QUESTION table, you can track information about the actual question itself (text of the question, what "section" it is, etc.)

Is there a good reason why you're using 8 separate tables?

[Missinglinq]

This type of thing is usually done with a Main Form, based on the personal data Table, and Subforms, one for each related Table. Using the Wizard to create the Subforms, Access will automatically insert the Primary Key, from the Main Form, into the related Records, on each Subform, as a Foreign Key Field in the Subforms underlying Tables. If these related Tables have more than a couple of Fields apiece, you might want to place each Subform the Page of a Tabbed Control.

Having said that, a survey/questionnaire is a kind of specialty database. Duane Hookom, MVP, has a survey database that he developed and offers, for download, to be used as a guide for others who are doing the same:

Duane Hookom's Survey Database

This app has been used by many, many people, over the years, for just that purpose.

...If all you're gathering are NAME/VALUE responses, you might be better off just using ONE table for ALL of their responses...

...Is there a good reason why you're using 8 separate tables...

Without knowing more about the data scheme, here, it's impossible to tell whether or not the eight Tables are appropriate, but most experienced Access developers will tell you that RecordSources with more than 25-30 Fields apiece suggests that the database is non-normalized.

Linq ;0)>

[alcapps]

you can always call the first forms ID. so do you have 8 forms? you can always default txtID = forms!firstFormName!controlnameforID
or make it one form with 7 tabs.. with sub forms in the tabs. then you can use me.parent.ID

any way if you have a example database here I can make the changes for you.