Data Entry Troubles

[Guest]

I have created a database in Access which has 8 tabs for our customer details
and those of additional applicants (mortgage). When I enter data into the
main applicant (set up on one table) the data is automatically entered into
the other applicants (set up in seperate tables). What have I done wrong?

 

[J. Goddard]

Are the controls in the "other" tabs, that are supposed to put data into
other tables, mistakenly bound to the same table as the main applicant?

If the data for the other applicants is to go to other tables, you'll
have to use VB to accomplish this.

Hope this helps

John

 

[John Vinson]

I have created a database in Access which has 8 tabs for our customer details
and those of additional applicants (mortgage). When I enter data into the
main applicant (set up on one table) the data is automatically entered into
the other applicants (set up in seperate tables). What have I done wrong?

Missed the point of how tab controls work, I'd guess.

A Tab Control is JUST a way to manage screen real estate. A textbox on
a Tab Control is bound to a field in the Form's Recordsource, and will
be stored there. You can't have eight tables on eight tab control
pages, except by using a Subform on each page.

In addition - if your design is set up to have a different table for
each applicant, your table design *is wrong* and needs revision before
you start playing with forms! What are your tables, and how are they
related? One Mortgage can apply to multiple Customers, I see; can one
customer apply for many Mortgages?

John W. Vinson[MVP]