concatenating forms

[ishan]

The Access database I'm working on contains about 250 fields. I tried making a form for this database, but I encountered problems while doing this as I couldn't fit all the fields in the same form. I ended up splitting it into 6 forms.
Now, the problem I face is that I can't get it to concatenate the information from the 6 forms into 1 record. Say for instance, I fill in some information in the first form(which contains the primary field), and click on the link to the next page (which inherits the primary field from the first form), it does take me to the next form. But, when I fill in the information in the second form and try to save the two forms, it gives me a "duplicate field" error. I know why it's doing this, but I'm not sure how to go about solving this problem.
I'd really appreciate it if someone can give me a few suggestions on how to solve the problem, and if possible give me some sample code. Thanks

[msebastian]

Does it matter if the fields are concatenated into one field.

Matt

[ishan]

Are you talking about transfering fields from one form to the next until I get to the last one and save the field as a whole into the table?

[msebastian]

Yeah this doesn't answer your question at all but don't you think its a bit too much to have a user fill in 250 fields even if they are on 6 forms.

[ishan]

The form is for a survey. I miscounted the number of fields, it comes up to around 150 fields (which is still quite a bit).
I think I might just split the table into 6 and link the individual forms to the corresponding tables. At this point, I think this might be a whole lot simpler to do than anything else. Thanks for the suggestions.