Using several forms to fill in one record on a table

pelicanbuyer

Registered User.
Local time
Today, 15:10
Joined
Dec 11, 2012
Messages
12
I would like to use several forms to help build one record in a table and I am just trying to get my head around the best way to do it. I am fairly new to access so go gentle with replies!

Form 1 with ask for details about one aspect of the client such as personal details.
I will then need a next button and it will go to form 2, summarising what has been inputted and now asking for the next lot of details such as their requirements.

I am guessing I could have 2 separate tables for the details and link the 2 but I have inputted lots of data already and I want to use that table as the source.

The main bit I am concerned about is when I go to form 2, how will it know to relate to the client I put in form 1?

I hope that makes some kind of sense but feel free to ask for clarification on any of it.

HELP!!!
 
i don't know if there is such a possibility (to insert data in a single row using to forms). But i have another suggestion: use the TAB control.
The real solution is to split the table so that you don't have to many empty fields.
 

Users who are viewing this thread

Back
Top Bottom