subforms and tabbed forms

Hi,

I would like to enter data from a long questionnaire into a database. Since
there are too many fields to fit into one table, I would to store the data in
one table for each section. In order to enter the data I would like to use a
tabbed form. Each tab will be a section of the questionnaire and will be a
subform. In the "overall" form I will have the id field. My question is how
can I easily move between the subforms when doing data entry. I would like to
say have the fields for Section B appear on screen when the last field in
section A is completed. Also, when the last field in Section B is completed I
would like to go to a new record.

Thanks.