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
