Data Entry Troubles Helen 01.09.2006 12:46:01 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?

Re: Data Entry Troubles "J. Goddard" <jrgoddard[ at ]NO_cyberus_SPAM.ca> 01.09.2006 18:47:29 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 Helen wrote: [Quoted Text] > 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?

Re: Data Entry Troubles John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 01.09.2006 21:04:22 On Fri, 1 Sep 2006 05:46:01 -0700, Helen <Helen[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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]