Where to start...
Well, from the previous responses you probably have an idea that your existing plan is at best fatally flawed. Let me be blunt and simply say you need to forget *everything* about this plan and start over. Tweaking the design by breaking it out into multiple forms or some other way won't help. Move on.
While it is not customary for contributors to this forum to offer to do someone's job for them, it is obvious you need more than a little help to get pointed in the right direction. It is also apparent from looking at your profile that this application is important and will help a lot of people when (and if) it ever gets built.
So, with that in mind, I would like to suggest that you provide as much detail about the actual *business* requirement for this application as possible (forget technical specs at this point). In other words, how would someone who knows only the basics about computers or databases describe the goal?
As an example, something like this would be useful:
"We need an application to capture and track information about recipients of foreign aid money. Data will be entered initially by aid workers in the field, either using a laptop with a "local" copy (replica) of the database, or using paper forms (for entry later at HQ). Data will include the recipient's name, home town/village (or specific address if available), phone (if avail.), age, gender, ethnicity, nationality, status (home, displaced, refugee camp, etc.), current residence/location (if displaced), plus any other data points needed for individual identification or statistical tracking. The system should provide the following reports..."
As Doug Finner pointed out, there are ways of architecting survey applications that require a very small number of forms and fields. There may also be good (and even free) examples of such applications, such as this one here from Brian Green of Automated Logic: http://www.automatedlogic.com/domblog.nsf/dx/DominoTeamSurvey
I think if you can clarify your requirements you will receive plenty of advice pointing to far simpler (to say nothing of better performing) ways of achieving your goals.
Anticipating your response...