Filling out multiple forms to create one record

[thexxvi]

Good morning,



I have a project where I have to create two forms to fill out one record. Unfortunately all of the fields that need to be filled out do not fit on one from, so I have to break it up in two. Is there a way that the user can fill out page one, then move to page two, and submit information typed in to form one and two to show as one record on the same table?

Thank you!

Cory

[thexxvi]

Just to be a little more clear...I have Table 1. I have Form 1 and Form 2. The user would complete Form 1, then would need to move on to Form 2 and complete that form as well. Once they have completed Form 2, all of the data entered in to both Forms would need to combine as one record in Table 1

[ItsMe]

I use the Tab Control within forms when I run out of real estate. Another approach I use is to break up the data entry process into stages. Different stages use different forms. I use VBA and fields in tables (such as Booleans and Session ID's) to keep track of where the user is, what their session ID is, which forms need to open, and which forms are allowed to be closed.

[thexxvi]

Thank you very much! I'll give the Tab Control a shot.